Forum Discussion
Tony88
Helper I
Helper IHow to add a dynamic average line on same axis in Power BI Line Chart?
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, bu...
Tony88Helper I
Helper Irajulshah
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
rajulshah
Resident Rockstar
Resident RockstarTony88 ,
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.
