Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

wallace13

Filtering Data Makes Secondary Y-Axis Disappear on Column/Chart in Power BI Service

Submitted by Advocate II on ‎02-28-2020 01:44 PM

When I use some filter choices, the secondary y-axis disappears.  It looks like it is trying to use just one axis when possible.

This is not desired.

 

No filters: has 2 axis

 

InkedNo Filter - 2 axis_LI.jpg

 

Some Filters: has 1 axis

 

InkedSome Filter - Only one axis_LI.jpg

 

I want my axes to remain independent.

 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎03-02-2020 01:52 AM

@wallace13 

 

In the Format section of the Visualizations pane, expand the Y axis card, turn Show secondary to On.

wallace13
Advocate II
Advocate II
‎03-02-2020 07:21 AM

I went and did this when selecting my filters and it resolved this one case, but it looks like you would have to do this for all views which would seem to trigger the vizualization to default back to the single axis.  As you might imagine, this isn't exactly a scalable solution.  The chart should have just one formatting rule.  When secondary axis is turned on, it should always be on, regardless of which filters are selected.

Idea Statuses