Is it possible to hide the Secondary Y axis for a line and stacked column bar?

[Anonymous]

I get the following line and stacked column bar. I would like to hide the secondary Y axis on the right. Is this possible?

[Dan8008]

Check labels to none.  Should solve it.

[HLandry73]

I agree with Pirdim, changing the color to hide the axis is a bandaid not a solution and not really an acceptable solution for the reasons listed above.  Please add this simple setting.  

[jdbuchanan71]

@HLandry73 

There is an idea submitted for this already but it needs votes in order to make it to production.

https://ideas.powerbi.com/ideas/idea/?ideaid=7ef6c2e4-c4ad-4884-a325-795f014fe15e

[Icey]

Hi @Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Anonymous]

Hi,

This problem is not solved yet. I guess this is a bug for MS Power BI.

Why can't disable 'Show secondary':

• If disable 'Show secondary', get the following; you can see the orange line (for rate %) goes down to the x-axis and becomes meaningless...

[jdbuchanan71]

@Anonymous 

Right you are, sorry.  The only thing I can think to do is change the text color on the secondary axis to match the chart background.

[Anonymous]

Thank you.

But, I don't have the options that you have. Do you use an upgraded version of MS Power BI?

[jdbuchanan71 · Accepted solution]

I am using the November 2019 version that just came out but it is available to everyone.

[Anonymous]

Thank you.

I've updated the desktop to 11/11/2019, and it works.

[jdbuchanan71]

Under the Y Axis formatting you can set "Show secondary" to Off

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

[pirdim]

hi @jdbuchanan71 . this actually doesn't solve the problem and above the @Anonymous pointed that out. When you try to disable secondary axis data will simply become useless as both column and line chart data now will be represented on same axis... As funny as it is - this problem still exist. And some time ago I posted similar issue with secondary axis which was eventually not answered: https://community.powerbi.com/t5/Issues/Secondary-Axis-align-zero-option-is-not-working-properly-Line/idc-p/979763#M54925

[jdbuchanan71]

Does setting the secondary axis label text color to white work for you?

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-hide-the-Secondary-Y-axis-for-a-line-and/...

[pirdim]

hi @jdbuchanan71 , thanks for your reply. I saw your comment about white color and to be honest I was using same workaround previously. But as all workarounds it is missing smth. It helps to remove annoying numbers but it fails in 2 things: first of all - this secondary axis takes some space (color doesn't change) which is crucial for me. 2nd thing - this color approach doesn't work on mobile version if user has auto change of theme (dark mode). I would just prefer PBI team add simple possibility to hide numbers... that's it

[Omitsky]

Another banger . This issue was giving me problems