Skip to main content

Power BI

Needs Votes

Axis with configurable units (/Interval)

Vote (1190) 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 (64)
Benny van Heugten's profile image Profile Picture

Kyle Durand on 28 Mar 2023 20:28:52

RE: Axis with configurable units (/Interval)

Our director knows the importance of how graphs should convey a story and being able to set the line intervals is a huge part of that, please make this ability possible!!

Benny van Heugten's profile image Profile Picture

Nidhi Sagar on 16 Feb 2023 05:32:27

RE: Axis with configurable units (/Interval)

Please! get this done already!

Benny van Heugten's profile image Profile Picture

Fredy James on 29 Nov 2022 03:42:01

RE: Axis with configurable units (/Interval)

Have been avoiding pbi for these and other reasons. With the current client don't have am option. Shame we have to go to ETL layer to fix data for simple config changes like this.

Benny van Heugten's profile image Profile Picture

Michael Jamieson on 19 Oct 2022 00:29:26

RE: Axis with configurable units (/Interval)

Can't believe this doesn't have more votes. Comparing year on year data is horrendous to visualise when there is a massive blow out, and the trend line looks near identical, when it should be alarming.

Benny van Heugten's profile image Profile Picture

Thomas Corey on 28 Sep 2022 18:31:37

RE: Axis with configurable units (/Interval)

This has been open for 6 years????? Please get on this

Benny van Heugten's profile image Profile Picture

Kevin Lee on 06 Sep 2022 00:50:53

RE: Axis with configurable units (/Interval)

This ability exists in Excel so it is odd that the same is not available in PowerBI.I would like to see an extension of this where as in Excel there are Major and Minor settings for the tick marks also. This would allow us to have the intervals for numbering set to allow ease of readability while having the smaller tick marks to give a better scale between.

Benny van Heugten's profile image Profile Picture

Karen Moore on 07 Jun 2022 00:16:22

RE: Axis with configurable units (/Interval)

The lack of the this critical feature makes Power BI visualizations far inferior to competing software. Current state is unacceptable to the managers using these reports.

Benny van Heugten's profile image Profile Picture

The A9 data guy on 30 May 2022 04:16:55

RE: Axis with configurable units (/Interval)

It's odd that this feature is still not implemented.

Benny van Heugten's profile image Profile Picture

David Webb on 09 Mar 2022 06:20:44

RE: Axis with configurable units (/Interval)

Must have.

Benny van Heugten's profile image Profile Picture

Jeremy Woo on 09 Mar 2022 05:25:15

RE: Axis with configurable units (/Interval)

agreed