Unusual behavior in visual

[Daryl_K]

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?

[PhilipTreacy · Accepted solution]

Hi @Daryl_K 

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.

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

Regards

Phil

[Daryl_K]

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.

[Daryl_K]

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

Thank you!

[PhilipTreacy · Accepted solution]

Hi @Daryl_K 

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.

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

Regards

Phil

[Anonymous · Accepted solution]

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