Forum Discussion
Issue with two axis on line chart
Hi all,
I want to use the line chart visual which has Axis, Legend, Value, Y2 and tooltips as an oportunity to be filled.
I would like to create the line chart the way that it shows me based on the filters a brand market share over time. this is easy as I just have to put it X= Times, Brand in Legend and Values which are my share. I also have a measure showing me the past year shares which also works perfectly fine. Is there a reason why power BI doesn't let me put in the past year shares in Y2? Is there something special about the visual that has to be considered? If I put Times, Brands,share and past years share in a table it works as it is suppose to.
Thanks for any tipp
Hi Anonymous ,
How about using Multiple Axes Chart - XViz? You can change the series type to line.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
Anonymous , Have you tried dragging the measure to Y2 Axis.
Check here
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/#_Dual_axis
- AnonymousNot applicable
It seems that power BI cannot handle two axis when there is multiple line charts. It only works if each value only cretaes one line
- Icey
Community Support
Hi Anonymous ,
How about using Multiple Axes Chart - XViz? You can change the series type to line.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- candresbqFrequent Visitor
Hello.
I created a line chart and it creates two axes for me, but I would like it to only take the axis on the left as a reference.
How can I turn off the axis on the right and make the two lines based on a single axis.
Thanks a lot.