Line and Clustered Column Chart - display a single Y axis only

[Anonymous]

Hi all, I have a visual as depicted below which, the Column values denote the sales performance of individuals, and the line value denotes the average of the group. As you can see below, there is a second Y-axis along the right side which is for the line value and is super confusing. Is there a way that I can control whether or not PowerBI will display the second Y-axis? 

for instance, when I choose a different period of time, the visual changes and looks far more intuitive.

[Icey]

Hi @Anonymous ,

Just like what @Greg_Deckler says, "Show secondary" icon under Y axis field could control whether the second y-axis appears.

Please let us know if this is helpful.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you @Icey  and @Greg_Deckler 

I just checked the Show Secondary setting and it is indeed turned off, I'm newish so my terminology is probably incorrect, my apologies. The PowerBI portal shows the secondary axis, however PowerBI desktop doesn't. The filters are all identical, this feels even more bizarre to me 🙂

Here's what it looks like in Desktop:

Here's what it looks like online:

Greg, to your initial question about the measures:

The Column Values is this measure:

New Pipeline = calculate(SUM(V_RPT_SF_New_Pipeline[Amount]))

The line value is this measure:

New Pipeline Average = calculate(SUM(V_RPT_SF_New_Pipeline[Amount]))/DISTINCTCOUNT(V_RPT_SF_New_Pipeline[OppOwner])

The page has two filters, a date range, which pulls from a date table, and a Region filter, the OppOwner column is linked to a User table, which has Region as an attribute (East, West, Central).

[Greg_Deckler]

@Anonymous - Seems like a bug then. Try turning it on in the Desktop and publish. Then, turn it off in the Desktop and publish. See if it stays off in the Service.

If not, You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Anonymous]

Thank you, Greg. I did re-publish after toggling the setting and that seems to have done the trick for now... 🙂

[Greg_Deckler · Accepted solution]

Can you screen shot or describe the configuration of the visual? What columns/measure are where? Under Y-Axis in the settings of the visual there should be a "Show secondary" option that controls this.