cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbiasker
Helper IV
Helper IV

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

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

10.PNG

1 ACCEPTED SOLUTION

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

View solution in original post

11 REPLIES 11
Icey
Community Support
Community Support

Hi @powerbiasker ,

 

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

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...

11b.PNG

 

@powerbiasker 

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.

SecondaryAxis.jpg

Thank you.

 

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

11c.PNG

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

Thank you.

 

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

jdbuchanan71
Super User
Super User

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

showsecondary.jpg

 

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

hi @jdbuchanan71 . this actually doesn't solve the problem and above the @powerbiasker 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-Lin...

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/...

 

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

Another banger . This issue was giving me problems 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors