Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver 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  
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

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
Icon for Resolver III rankResolver III
3 years ago

Hello,

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

 

Regards,

Chandrashekar B 

 

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    ok can you please elaborate more 

    • Chandrashekar's avatar
      Chandrashekar
      Icon for Resolver III rankResolver III
      3 years ago

      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

       

      • eliasayyy's avatar
        eliasayyy
        Icon for Memorable Member rankMemorable Member
        3 years ago

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