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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Chandrashekar
Resolver III
Resolver III

Dynamically Changing Y Axis : Clustered Column Chart

Hello,

 

How to dynamically change Y axis in clusterd column chart.

Below example Y axis should be 55%.

 

Chandrashekar_0-1684232414134.png

 

Regards,

Chandrashekar B

 

8 REPLIES 8
eliasayyy
Super User
Super User

when you press on visual , you will be able to format the visual , go to y-axis and tehre is range 

create a measure

y_max = if( maxx(all(date[yearmonth]),[your measure]) < 0.55, 0.55,1)

this measure means that if max of your measure is less than 55% , then the max axis is 55% but if it is greater then max is 100%

now when you go to format , and y-axsi ranges, you will find max and min and next to them an fx button , press on fx of max and choose this measure 

Hello,

I have around 15 graphs in the sheet and Y axis should change accordingly.

 

Regards,

Chandrashekar B 

 

ok can you please elaborate more 

Hello,

I need to take max value from each graph and assign to Y axis.

For ex: Graph 1 - 52.9 % is max so I need to assign to Y axis

Graph 2 - 57.9 % is max and same need to assign to Y axis

Chandrashekar_0-1684296549416.png

 

So if i understood correctly you want to put all the max of each L like p1 p1 p1 l2... in the graph?

Hello,

 

Exactly and same should align to Y axis.

 

Regards,

Chandrashekar B

Hello,

 

Can you please help me to get solution.

 

Regards,

Chandrashekar B

Hello,

 

Can you please help me to get solution.

 

Regards,

Chandrashekar B

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors