Growth rate vs CAGR

[Anonymous]

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

[v-chuncz-msft]

@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]

@v-chuncz-msft 

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