Forum Discussion
Chandrashekar
3 years agoResolver 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%.
Regards,
Chandrashekar B
8 Replies
- eliasayyyMemorable Member
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- ChandrashekarResolver III
Hello,
I have around 15 graphs in the sheet and Y axis should change accordingly.
Regards,
Chandrashekar B
- eliasayyyMemorable Member
ok can you please elaborate more