Forum Discussion

RashmitaR's avatar
RashmitaR
Icon for Helper IV rankHelper IV
9 years ago

show past 4 quarters data

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.
Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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. :smileyhappy:

     

    Regards