Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
Thanks for the reply. How does the year over year change works here.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |