cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

modify the labels shown on x-axis of the visualization chart

I am working on PowerBI stacked Bar chart visualization. I want to change the values(labels) shown on x-axis.
Please see the image below, x-axis is starting from 0 and ending at 4(In the sample values are small so it is showing from 0 to 4).
How to change the x-axis value(labels) starting from 0,15,25.. or if i want to give it with decimals as 0.0,5.5,...I was seeing the options provided in Format painter but could not find the appropriate option which changes the values on x-axis.

axis.png

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: modify the labels shown on x-axis of the visualization chart

@RyanPB try chngin scale type to log and enter value in "End" 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Community Support
Community Support

Re: modify the labels shown on x-axis of the visualization chart

hi, @RyanPB

You can custom all the format of x-axis in Format->X-Axis

You can custom x-axis's scale type Linear/Log, Start and End, decimal places ,etc. 

If not your case, you could post your new idea in Power BI ideas and make this feature coming sooner.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: modify the labels shown on x-axis of the visualization chart

I hava only scale type "Linear", and when i gave the value in End it is showing 0,20,40.. But how to predict the value on x-axis, as we never know dynamically what is the max value we are showing  on the chart, and the chart we are showing the calculated measure and we cannot know what is the max/min value.

Highlighted
Community Support
Community Support

Re: modify the labels shown on x-axis of the visualization chart

hi, @RyanPB

After you enter 0 in Start, you couldn't select "Log" in scale type. So remove 0 in start.

20.PNG

if you don't custom End value, the visual will set the max value of the data after filter for the end value dynamically.

and the grid values will vary dynamically with the size of the current visual.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: modify the labels shown on x-axis of the visualization chart

@v-lili6-msft - Thanks for the inputs. My PBI version (Mar2018) doesn't support log Scale type. 

 

linear.png

Highlighted
Community Support
Community Support

Re: modify the labels shown on x-axis of the visualization chart

hi, @RyanPB

Upgrading to the latest version will allow you to experience many new features, you may update the latest version and 

then try it again.

https://powerbi.microsoft.com/en-us/desktop/

 

hope it can help you.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors