Skip to main content

Power BI

New

Ability to align Y axes values when aligning to zero.

Vote (9) Share
Gabriel Peterlini's profile image

Gabriel Peterlini on 13 Jun 2018 21:10:28

When using a "Line and Stacked Column" chart you can use the option to align to zero so both axes start at zero, but there's no way to align all other values.
For example: One of the columns on a chart corresponds to a value of 98K and you want to have a dot on line above it corresponding to 100K, that doesn't necessarily happen even when aligning the start of both axes to zero since the increment is different on both axes, therefore you end up with the column going over the dot because the value of 100K on the left axis is corresponding to approximately 120K on the right axis.

Comments (3)
Gabriel Peterlini's profile image Profile Picture

c8510940 6ab9-48e0-ab5a-b472be944e02 on 06 Jul 2020 00:13:31

RE: Ability to align Y axes values when aligning to zero.

'@Schreef, it looks like it does, but it doens't. Look at the actual values in the chart of the second Y Axis

Gabriel Peterlini's profile image Profile Picture

ae31c5ff 4a01-4a9d-a925-b509901dd096 on 06 Jul 2020 00:06:16

RE: Ability to align Y axes values when aligning to zero.

That isnt the way around it, that is the exact purpose of that feature.

Gabriel Peterlini's profile image Profile Picture

7d649ef8 880f-4e9a-adcd-778785a4e521 on 05 Jul 2020 23:22:17

RE: Ability to align Y axes values when aligning to zero.

Found a way around it.
Under the "Y Axis" customization, turn off the "Show Secondary" option, this makes it so the dots align to the same axis as the columns.