Forum Discussion
Dynamic growth rate graph
Hello all,
I have a simple graph that displays the yearly revenue of a department. I would like to add a dynamic growth rate line graph to this visual. I am using date filters, such as quarters and months, as well as account executive names and account names. How can I create a measure to create this dynamic growth rate line in my graph?
I solved my problem through using quick measures. There is a YoY growth option that requires a date hierarchy. I can then filter by quarter and month, and the graph changes automatically.
5 Replies
- byr10112Microsoft Employee
Dynamic as in the growth rate changes based on the filter selections
- parry2kSuper User
byr10112 Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - v-janeyg-msftCommunity Support
Hi, byr10112
Can you share some insensitive sample data and your dynamic growth calculation logic? So, we can help you soon.
It is difficult to provide substantial help without data.
Best Regards,
Community Support Team _ Janey - byr10112Microsoft Employee
I solved my problem through using quick measures. There is a YoY growth option that requires a date hierarchy. I can then filter by quarter and month, and the graph changes automatically.