Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a line/bar combo chart and I want to disable the secondary Y axis so both the bars and lines run off the same Y axis.
According to MS article https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart?tabs=powerbi-d... there is an on/off toggle switch against Secondary y-axis, however I am not seeing this option.
Can anyone please help?
Thanks!
Solved! Go to Solution.
I would like to apologize for the belated reply.
Have you solved your problem? If not, try the following steps:
The following screenshot is without closing the Values of Secondary Y Axis.
You can turn off the button as shown so that the Column y-axis and the Line y-axis share a common y-axis.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would like to apologize for the belated reply.
Have you solved your problem? If not, try the following steps:
The following screenshot is without closing the Values of Secondary Y Axis.
You can turn off the button as shown so that the Column y-axis and the Line y-axis share a common y-axis.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It appears that this solution does not always work (I'm on the february 2024 release).
I made sure that both minimum and maximum of Y-axis and secondary Y-axis are on "Auto", "Align Zero's" is on, values of the secondary Y-axis is turned off, but I still get different scales for line and bars.
A workaround could be to calculate the maximum of both set of bars and the line, and add that to the maximum of the range, but that is a lot of work, and needs to be done for every combination of measures used. In the past it was sufficient to uncheck the "show secondary axis" check box to get the wanted result.
Please bring this option back.
Hi @mboucher_rcr ,
Secondary y-axis toggle button can be set to On to display options for formatting the line chart portion of the combo chart not to disable the secondary chart .
If you dont need the secondary axis just remove it from the secondary axis.
As you the secondary y axis is not visible , you can update th version of your power bi desktop.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
Hi,
There doesn't seem to be any update available to my version: 2.124.1554.0 64-bit (December 2023)
There is no toggle button visible. I don't need the second axis, but I do need the lines showing, I just want the columns and lines to share the same Y axis.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |