Show last 6 months based on user single slicer selection (20:03)
https://www.youtube.com/watch?v=d8Rm7dwM6gc
Creates a copy of Date table (PreviousDates) that will be filtered to the last 6 months of dates based on the slicer selection, use PreviousDates to filter Date table, create a calculation group that will calculate previous 6 months of SELECTEDMEASURE(), finally apply calculation item as a filter of the visual to render the previous 6 months based on slicer selection.
Calculation item CALCULATE must REMOVEFILTER on Date table and KEEPFILTERS on PreviousDates
Calculation Group starts at 14:00
Comments
Post a Comment