show past 4 quarters data

[RashmitaR]

Hi, I have a trend graph with axis as a quarter column and month name column and values as revenue.I want to create a trend graph where I can show the trend of the last 4 quarter values.Could some one please help me achieve it.

[v-ljerr-msft]

Hi @RashmitaR,

If I understand you correctly, you can add a new calculate column "IsLast4Quarter" in your table first. Then you should be able to use it as a visual level filter(IsLast4Quarter is 1) to create a trend graph where you can show the trend of the last 4 quarter values.

In addition, here is a similar thread for your reference. 

Regards