Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sequential Growth with dynamic date filtering

Hi All, 

Greetings!!

 

I need one help related to Power BI. We have one requirement from client where we have to show sequential growth in bar graph showing 12 quarters in X-Axis. For example, if we have selected FY20 and Q4 then X-Axis will show data from FY18 to FY20 and once global date filter is changed to FY19, it will show data from FY17 to FY19. Due to this global filter, i am unable to create any calculation for sequential growth. Can anyone please help me out on this? 

 

Thanks,

Paras Sachdeva

Need Help

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago
    can you provide some dummy data? can you say what you have tried to do already. have you created any calculations yet and can you say wha tyou are struggling with specifically?
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi vanessafvg 

      Thanks for your reply. I have created calculations for Y-o-Y growth using SAMELASTPERIOD function and for Sequential growth using DATEADD function. Problem is when i am using date global filter(drop down), system is only able to get single value instead of giving me growth for 12 quarters. 

      Calculations created:

      Y-o-Y: CALCULATE([Total Income],SAMELASTPERIOD(Year_Qtr[Date]))

      Seq growth: CALCULATE([Total Income],DATEADD(Year[Date],-1,QUARTER))

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        5 years ago
        I still dont quite understand your problem, in your drop down you have one date, but you saying you want to get a list of dates?

        please provide some screen shots if you can't provide dummy data or a pbix.

        with the screenshots point out what is wrong, and then give me an example of what you want it to do.