Forum Discussion

Quiny_Harl's avatar
Quiny_Harl
Icon for Advocate III rankAdvocate III
5 years ago

Line and column chart with 2 lines shown on different axis

I would like the purple line values on the left axis, along with the bar values, and the red line values on the right axis. Power BI allows all line measures to be shown only on a single axis which in my case doesn't work because the red line values are miniscule compared to the purple line values and appear at the bottom. It is a super simple feature and it is disappointing that Power BI doesn't have it.

Is there a workaround solution for this?

Need Help

2 Replies

  • dkaushik's avatar
    dkaushik
    Icon for Resolver II rankResolver II
    5 years ago

    Hi Quiny_Harl ,

     

    If you really need to achieve this, you can create a line chart and put it on top of this one with bachground turned off and transparency 100%. You'd also need to make the axis static by defining start and end values under formatting pane. There would be many other formatting settings that you need to take care of as you progress through it.

     

    Thanks,

    Dheeraj
    If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.