วีดีโอ

hopefully this week

should be out this week

@@Ninjhaw yes, that's equivalent to four measures

@@DAXJutsu Nice. will try this method sir. Thank you sir Dane

@@DAXJutsu the problem is the other pair of selected and non selected measure will go above the other bars since it's a stacked column chart.

@@Ninjhaw you need to change the viz to clustered column for multiple measures involved. Whether we like it or not, that is how stacked column charts behave when there are two visible measures at a time in a category.

What I did po is I created another column chart and I place it behind my actual chart. Para mag ha highlight nlng po yung background nung visual for selected month but I think it is not easily maintanable for me

@@Ninjhaw nasa description Yung link.

@@DAXJutsu thanks sir

updated na po ang link

@@DAXJutsu Thank you po Sir!

My credit sales table has over 4M rows while payments has 7M. The calculation is stils relatively fast at the customer level. It's a different story once expanded to the invoice level. I figured it was due to conditional formatting so I removed it and it drastically improved the performance.

@DAXJutsu WOW...that is awesome...I have a report currently that dynamically buckets receivables based on slicer selection but it is slow and not near as many lines. I don't think I am using the most efficient way to calculate and segregate by age once the date is changed by the user which is why I was so intrigued by your report. There aren't too many examples that I know of out there that can dynamically age receivables from the static data based on date selection in a slicer....most only give you a view of current aging and the aging buckets will simply disappear as you filter back in time without recalculating the age based on a date filter. I very much look forward to your tutorial.

Thank you. Updated na ang link.

@@DAXJutsu Thank you sir!