Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Growth rate vs CAGR

Hello All,

 

i have tables like this

 

Now, iam asked to visualize Products having growth rate lesser than CAGR (Based on average sales). Iam able to get formulas for Cagr in website, but unable to match with my scenario(like which columns to use). I have period of 4 years in my table. Can anyone tell me how to calculate Growthrate and Cagr and what will be best visual to show this using columns in my tables

Need Help

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous 

     

    You may research quick measure Year-over-year change and take a look at this post, then try using Line and clustered column chart.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-chuncz-msft 

      Thanks for the reply. How does the year over year change works here.