In the line and clustered column chart and line and stacked column chart visuals, there is the option to use two measures, and view them displayed on either one or two y axis.
On basic, single-measure visuals where small multiples are used, the y axis can synchronise across the differnt small measures using the 'shared y axis' option in the visual options.
The issue is that when the two-measure visuals try to use small multiples, the y axis do not work properly. The secondary measure will not be taken into account when the axis range is designed.
I'm guessing that this is the result of the small multiples feature for these charts not having the axis designed to use the highest of all values. The range of the shared y-axis is determined entirely by the primary measure used, and not by the full range of both of the primary and secondary.
I have prepared an example pbix and visuals (fake data). As you can see, the y axis cuts out at the 800 mark, when it should go up to above 2000. The problem occurs regardless of whether the small multiple panes are vertically or horizontally aligned.
Compare this to how the data looks if it was shown on two seperate visuals
The Target value for Man-USA is very high, but in the first picture (blue columns) , the number is displayed correctly on the tooltip but the marker is too low.
-
mattlee
on:
“Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on:
Fix the Date function in DAX
-
Stinkys
on:
Cannot login to community site
-
reubwork
on:
May 25 update for Snowflake Connector v2 has broke...
-
dmkblesser
on:
Unable to open existing PBIP files
- DamoUK on: Gateway issues
- davidebacci on: Total Labels not following dynamic formatting rule...