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)
RE: Axis with configurable units (/Interval)
I have a chart that has accounting period on the x-axis (numbers 1-12) but PowerBI automatically selects the Major Unit (as per Excel's axis options for a chart terminology) as 2 instead of 1. This is obviously not ideal as accounting periods are quite a common x-axis value (at least for me) and an end user will be much more comfortable seeing all the periods shown. It'd be ideal if the same options as are available for an Excel chart are available for a PowerBI chart where axis options are concerned.
RE: Axis with configurable units (/Interval)
This is much awaited feature in Power BI . wondering, why it hasnt been made available right away .
RE: Axis with configurable units (/Interval)
This is a must have.
RE: Axis with configurable units (/Interval)
Has anyone figured out a way around this?
RE: Axis with configurable units (/Interval)
Please! We need this option. This is basic in excel, so I don't understand why it's not an option in Power BI.
RE: Axis with configurable units (/Interval)
soooo frustrating
RE: Axis with configurable units (/Interval)
Indeed, the ability to control gridline interval helps to make the chart more readable, and can provide specific business meaning when users think in certain intervals. As was previously noted, this feature exists in Excel and is quite helpful at times.
RE: Axis with configurable units (/Interval)
Please, please, please!! My boss won't take me seriously with these unfriendly intervals. He thinks I'm incompetent so I keep throwing Power BI under the bus. Sorry 'bout that.
RE: Axis with configurable units (/Interval)
This is something that leadership is continuously asking for. I can do it in excel and Qlik but not Power BI
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.