Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
GregWoolley
New Member

Customise Bar chart axis

Hi all,

 

I would like to control the max value of my y axis on a bar chart in a dashboard. Currently two adjacent bar charts have differing max y axis values of £1M and £2M (auto-generated due to values within the relevant data).

 

Can I control both y-axis so they both have max values of £2M and therefore the scales of the adjacent charts are the same?

 

If so, what would be the most straightforward way please.

 

Thanks, Greg

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @GregWoolley ,

 

Refer this, for continuous axis tick marks, you cannot control the format string. Power BI chooses the best tick interval based on your data range, and creates a minimal format string for this unit interval, to preserve space.

 

My test:

vtangjiemsft_0-1701311820445.pngvtangjiemsft_1-1701311836733.png

vtangjiemsft_0-1701312753462.pngvtangjiemsft_1-1701312768872.png

 

Best Regards,

Neeko Tang

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

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

Hi @GregWoolley ,

 

Refer this, for continuous axis tick marks, you cannot control the format string. Power BI chooses the best tick interval based on your data range, and creates a minimal format string for this unit interval, to preserve space.

 

My test:

vtangjiemsft_0-1701311820445.pngvtangjiemsft_1-1701311836733.png

vtangjiemsft_0-1701312753462.pngvtangjiemsft_1-1701312768872.png

 

Best Regards,

Neeko Tang

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.