Report Visual on Web Differs from Report Visual in Power BI Desktop - Secondary Axis

Question

Hi all, I just found a new issue which did not occur before.

So, I have built several visual reports in my Power BI Desktop, and have published them to the BI web without any issue.

Today, I found that all reports' (Old Publication and New Publication) visuals in the website, changed abnormally (without I did any change to my PBIX file and without having it re-published).

Such as, a chart in my report does not use double axis (secondary axis), but the outcome in the web, showed as if the line-chart is standing on secondary axis, without displaying the secondary axis itself.

Those issues just arose today, and only to the web visual.

The visual in PB desktop has no issue at all.

Anyone face the same issue?

Thank you.

v-xuding-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Do you download the pbix from Service? Does it work fine?

I searched in Issues. But there is not similar topics about this. What data source do you use? Can you please share a dummy pbix file that we can test. If you can't share, please share a few screenshots? Then we can understand clearly.
&nbsp;

anonymous · Answer

I'm getting the same issue.&nbsp; Graph looks perfect in desktop, but the Shared Axis is no longer working in the service.&nbsp; Notice that the line 152K is being displayed above a value of 188K&nbsp;

anonymous · Answer

Turning on "Show Secondary" under "Y-Axis" seems to indicate that this visual no longer lets the columns and lines share the same Y Axis values. Turning it off again doesn't restore the correct display.

Here is what it looks like with the 2nd axis showing, confirming what it is doing.

anonymous · Answer

I've posted this as an issue, link below&nbsp;https://community.powerbi.com/t5/Issues/Shared-Y-Axis-no-longer-functioning-for-a-Line-and-Column-Chart/idi-p/1093579#M56892

anonymous · Answer

I have located a potential fix.&nbsp;In my example the Y-Axis has been set to start at 0, rather than auto.&nbsp; The end is set to Auto though.&nbsp; Something has changed on the service which has carried through this Start at 0 into the secondary Y-Axis.&nbsp; The Service see's this setting and is choosing to use the secondary axis, regardless of whether it is toggled on.&nbsp;By change the secondary Y-Axis settings to both be "Auto", then toggling&nbsp;the secondary Y-Axis off again, the graph goes back to displaying correctly.

Forum Discussion

Report Visual on Web Differs from Report Visual in Power BI Desktop - Secondary Axis

5 Replies

Related content

secondary axis

Different scale for secondary Y axis

Different schema into different destination

Combo Chart Disable Secondary Y Axis

Remove Secondary columns in Matrix Visual