Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago

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

  • eliasayyy's avatar
    eliasayyy
    Memorable 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 

    • Chandrashekar's avatar
      Chandrashekar
      Resolver III

      Hello,

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

       

      Regards,

      Chandrashekar B