Skip to main content

Power BI

Needs Votes

Axis with configurable units (/Interval)

Vote (480) Share
Benny van Heugten's profile image

Benny van Heugten on 20 Jul 2016 19:33:24

Configurable option of Units (Interval) for the axis in a graph. Now PowerBI automatically choices to units between values on the size of the graph and the data. As an example with a small graph and values ranging from minus -200 and +400 the unit PowerBI choices to use is 200. In this example data becomes hard to understand. If there is an option to set a unit on the axis, we could improve visibility if the automatic one doesn’t fill the needs. In the example we could set the unit of the y-axis to 50, this will increase the number of values on the y-axis.

Maybe the number of labels will increase on the y-axis and not enough space to put them. So I can imagine design team wants to make the label part dynamic? But the graph axis lines based on the value put.

Comments (35)
Benny van Heugten's profile image Profile Picture

a0d7d643 075d-40c4-9f93-125b5a7063c2 on 05 Jul 2020 23:17:27

RE: Axis with configurable units (/Interval)

Like when is this something that will happen? Frustrating using Excel to create charts when you have a great tool in the making.

Benny van Heugten's profile image Profile Picture

2bd8993e 7d5c-4f69-9fc7-951c3bd5fc92 on 05 Jul 2020 23:07:05

RE: Axis with configurable units (/Interval)

Dealing with data that has contract expiry dates at 12, 36, 48, 60 months... the axis needed 12 mth intervals yet defaults to 20 months.

Benny van Heugten's profile image Profile Picture

40fcaa3e 2d77-4947-8cb9-424f27b1a5a6 on 05 Jul 2020 23:00:21

RE: Axis with configurable units (/Interval)

Something so simple and overlooked; why is this still an issue after more than a year? What about Major and Minor gridlines and tickmarks, too?

Benny van Heugten's profile image Profile Picture

c026e96b f643-465e-a5f4-98d97a693812 on 05 Jul 2020 23:00:08

RE: Axis with configurable units (/Interval)

Just voted. Indeed very frustrating!

Benny van Heugten's profile image Profile Picture

1b33da64 15be-486e-ac71-46360088bc86 on 05 Jul 2020 22:42:11

RE: Axis with configurable units (/Interval)

Yes please. This is very frustrating for me. For example, I'd like to be able to have a histogram centered around 50% with a min value of 30% and max value of 70%, but I'm being forced into label intervals of 0.2 so when I set 0.3 as a min value, it forces it down to 0.2, which makes the entire chart imbalanced.