Last x number of quarters

[robofski]

I have a report that shows revenue by qtr and it works great except that the report layout means that once I get more than 14 quarters I get a scroll bar along the x axis which is a real pain as there are several charts and each one would need to be scrolled right to see the current data.

I'm trying to figure out a way to just show the current quarter (regardless of where in the quarter we are) and the previous complete 13 quarters.  The relative date slicer doesn't allow quarters and using any of the other options effectivly alters the start of the first data point and is missleading on the chart.

I'm sure there must be something I could do on my date table but I'm struggling to come up with the creative DAX required, any pointers?

Dan

[v-yulgu-msft · Accepted solution]

Hi @robofski,

To only show last 14 Quarters including current quarter on Chart, please first create a Rank list based on quarter number.

Rank = RANKX('Table','Table 2'[QuarterNo],,DESC,Dense)

Add the Rank column into visual level filters.

Best regards,

Yuliana Gu