Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Unusual behavior in visual

I have a bar / line chart visual that is not displaying the line values correctly. To be absolutely sure the screenshot below is from the Show as Table view. You can clearly see the 3MRA line does NOT match its values in the table!

 

I've deleted and recreated the chart and the measure, but no difference. I've never seen this kind of behavior before. Any ideas?

 

2021-11-11_21-26-23.png

2 ACCEPTED SOLUTIONS
PhilipTreacy
Super User
Super User

Hi @Anonymous 

 

The minimum and maximum values for 3MRA are vastly different.  The scale on the secondary Y axis isn't large enough to display them all properly.  If you remove the two large values for 3MRA the line displays fine.

 

To illustrate, change the end value on the secondary Y axis to something small like 6000, and all your smaller values will now appear on the line.  The really large ones will of cours ebe off the top of the chart, but this demonstates the issue.

yax4.png

 

 

Change the secondary Y axis Scale Type to Log and you can see all the values for 3MRA

yax5.png

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Anonymous
Not applicable

I agree, your 3RMA values are plotted on the secondary Y axis (millions) not the 1st Y axis (thousands)  what you  are seeing is the values relative to the axis and your 3RMA are displayed relative to the Millions, not Thousands

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

So everyone was absolutely correct on this (I am still a PBI newbie), but in following everyone's advice I noticed a peculiar and undesirable (for my setup, anyway) behavior. For combo bar/line charts like this it's impossible to "sync" the y axis between the columns and the lines, which makes for a lot of confusion. Whether the secondary y axis is turned on or off, that only seems to make the secondary y axis legend visible or not - the lines are still on a completely different scale. If I configure the "end" for the secondary axis to use the column values for scaling (instead of Auto) it brings it down a little, but it's still on a totally-different scale.

 

There should be an option to sync them completely. In my case, for example, one of the lines is a goal line, and it looks like the columns are consistently exceeding the goal when in fact they aren't. I've pored over all settings and I don't see any way to really make an absolute sync between the two y axis. Am I missing something?

 

EDIT: I updated my version of Desktop and see that now there is an option to zoom on the secondary y axis also. Using this I can manually "force" a scale match between the two. It works, but is rather inelegant and I have to redo it every time.

Anonymous
Not applicable

You are both of course absolutely correct. No idea how this escaped me (I blame the head cold).

 

Thank you!

PhilipTreacy
Super User
Super User

Hi @Anonymous 

 

The minimum and maximum values for 3MRA are vastly different.  The scale on the secondary Y axis isn't large enough to display them all properly.  If you remove the two large values for 3MRA the line displays fine.

 

To illustrate, change the end value on the secondary Y axis to something small like 6000, and all your smaller values will now appear on the line.  The really large ones will of cours ebe off the top of the chart, but this demonstates the issue.

yax4.png

 

 

Change the secondary Y axis Scale Type to Log and you can see all the values for 3MRA

yax5.png

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

I agree, your 3RMA values are plotted on the secondary Y axis (millions) not the 1st Y axis (thousands)  what you  are seeing is the values relative to the axis and your 3RMA are displayed relative to the Millions, not Thousands

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.