Forum Discussion

Akahn's avatar
Akahn
Icon for Advocate IV rankAdvocate IV
11 years ago

Force Single Y axis on combination charts

I have a bar/line combo chart. I want to force the visual to ONLY use a single Y axis. Can I force this behavior?   Right now when I hide the second axis, it doesn’t change the chart. For example, ...
Hanson97's avatar
Hanson97
Frequent Visitor
4 years ago

For people still facing this problem i have found a solution !

1. Under "Y Axis" in format pane , you will see an option "Show Secondary". It will be defaultly in "Off" position even though a secondary axis is visible.

 

2. Here is the important part, switch the "Show Secondary' switch to "On"position and back to "Off" position. This will trigger the power bi visual to remove the secondary axis.


Power BI team should work on automatically switching the "Show secondary" switch to "On" position when a secondary axis is shown. But we manually switching it On/Off is triggering the required actions. 
Hope this helps! Mark this as solution to help others.

Thanks,
Hanson






 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks, Hanson.  That worked perfectly for me.  I've been using MS tools long enough - I should have thought of this!