Power BI

Needs Votes

Axis with configurable units (/Interval)

Vote (1139)

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 (62)

Comments (62)

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.

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.

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

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.

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.