Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a line chart with revenue by region (4 regions). I need to add a dynamic average line (not from the power bi trend line) for all regions to the same axis. So I tried adding it, but I could not add it. It used to be easy, all you have to do is drag it to the value field, but now we have the Y axis and secondary Y axis. I could not add it.
Is there an easy way I can add this? Please help me out. Any help will be highly appreciated.
The output result I want is below. (Red line is my average line) I don't want a dual axis.
This is what I got so far.
Sample file
https://drive.google.com/file/d/1PnFHbpYGvZ9DiBjlEJp38r3XhrI2NmGd/view?usp=share_link
Data
Thank you so much
@rajulshah
Thank you so much for your response. I want all lines including the average in one line chart and on one axis.
I just try to do what you say, but it won't allow measures to add it to the Y axis tho. This is where I am having a hard time. Can you please tell me why is that? Just trying to get into a 1 chart.
Again, thank you
@Tony88 ,
It's the reason as mentioned here:
"Please know that you can either plot the legends and one measure in Primary Y-axis OR you can have your measures in both Primary and Secondary Y-axis."
You can have either of two approaches.
@Tony88 please mark the solution as accepted to help fellow Power BI Users.
Thanks.
@rajulshah
I was able to do this wit this DaX. So I can not accept your answer. I will post it later. Thank you so much for your input
@Tony88 ,
Please know that you can either plot the legends and one measure in Primary Y-axis OR you can have your measures in both Primary and Secondary Y-axis.
OR
You can plot the below graph:
Please let me know if this didn't help.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |