March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
Hello,
How to dynamically change Y axis in clusterd column chart.
Below example Y axis should be 55%.
Regards,
Chandrashekar B
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
19 | |
15 | |
14 | |
10 |
User | Count |
---|---|
62 | |
25 | |
24 | |
22 | |
16 |