Power BI Axis Increment

[obartolo]

Does anybody know of a way to edit the increments of an axis? need to set them to 0 60 120 180 etc ....

using PowerBI Desktop

chart type is stacked bar chart
data type is whole number

thanks 

[rohit1991]

Hi @obartolo ,

In Power BI Desktop, adjusting the axis increments directly to custom values like 0, 60, 120, 180, etc., isn't available as a built-in feature for bar charts. However, you can achieve this effect by manually setting the axis start and end points and then adjusting the “Units” for the axis if the option is available.

For a whole number axis (like your stacked bar chart), you can set the minimum and maximum axis values in the Format pane under the X-axis (or Y-axis) settings, and if there is an option called "Interval" or "Units", you can set that to 60. This forces the axis to show ticks at every 60 units.

If the Interval option isn’t available or doesn’t behave as expected, another approach is to create a calculated column or measure that rounds your values to these increments and uses that for the axis, but usually for the axis ticks the formatting options should suffice.

Steps:

1. Select your stacked bar chart.

2. Go to the Format pane.

3. Find the X-axis (or Y-axis) settings.

4. Set the Minimum to 0 and Maximum to your max value (e.g., 180 or more).

5. Set the Interval to 60 (if the option is available).

If you want to automate this or handle it through DAX, here’s a simple DAX measure example that rounds values to the nearest 60, which could help with grouping:

RoundedValue = ROUND([YourValue] / 60, 0) * 60

Use RoundedValue in your visual to create categories at these increments.

[v-pnaroju-msft]

Hi obartolo,

Could you please confirm if you have submitted this as an idea in the Ideas Forum? If yes, kindly share the link here, as it will be useful for other community members with similar feedback.

If we do not receive a reply, we will go ahead and close this thread. For any further questions or discussions, please start a new thread on the Microsoft Fabric Community Forum. We will be happy to assist you.

Thank you.

[v-pnaroju-msft]

Hi obartolo,

Could you kindly confirm whether you have submitted this as an idea in the Ideas Forum? If so, please share the link here, as it would be helpful for other community members who may have similar feedback.
In case we do not receive a response, we shall proceed to close this thread. For any further discussions or queries, please initiate a new thread in the Microsoft Fabric Community Forum, where we will be glad to assist you.

Thank you.

[v-pnaroju-msft]

Hi obartolo,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi obartolo,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi obartolo,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft]

Thankyou, @lbendlin , for your response.

Hi obartolo,

Thank you for reaching out to us through the Microsoft Fabric Community Forum.

We understand that you would like to set fixed tick intervals (e.g., 0, 60, 120, etc.) on the axis in Power BI. Currently, the default visuals in Power BI do not support this functionality. However, you may consider the following workaround:

1.Manually adjust the Minimum and Maximum values in the Y-Axis settings.

2.Select an appropriate data range to allow Power BI to auto-generate logical tick intervals.

3.Enable Data Labels to display precise values, even if the axis ticks do not align exactly with your desired intervals.

If the workaround did not resolve the issue, we kindly request you to submit an idea using the link Fabric Ideas - Microsoft Fabric Community.

If this response addresses your query, we kindly request you to mark it as the accepted solution and provide kudos. This will help other community members with similar concerns.

Thank you.

[lbendlin]

I don't think you can do that with default visuals.  It is easy to do with Deneb, for example.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com