display current quarter and last 4 quarters in desktop

[Anonymous]

Hi All,

Can you please help me how to display current quarter and last 4 quarters in desktop?

for eg : When user selects q3 2021 from my slicer, then my visual should show q3 2021, q2 2021, q1 2021, q4 2020 and q3 2020

Also, if user selects q4 2021 from slicer, then my visual should show q4 2021,q3 2021,q2 2021,q1 2021 and q4 2020

and so on

Please help

[AllisonKennedy · Accepted solution]

@Anonymous  

In order for this to work you could create a table that is not related to your data and use that in the slicer. Then you can use DAX to add the filter.

You could also try:

Total Sales = SUM(Sales[Sales])

Last 5Q Sales = 
VAR _DateContext = MAX(DimDate[Date])
RETURN

CALCULATE( [Total Sales] , DATESINPERIOD(DimDate[Date], -5, Quarter) )