topic Dynamically Changing Y Axis : Clustered Column Chart in DAX Commands and Tips

Dynamically Changing Y Axis : Clustered Column Chart

Chandrashekar — Tue, 16 May 2023 10:21:17 GMT

Hello,

How to dynamically change Y axis in clusterd column chart.

Below example Y axis should be 55%.

Regards,

Chandrashekar B

Re: Dynamically Changing Y Axis : Clustered Column Chart

eliasayyy — Tue, 16 May 2023 11:11:27 GMT

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

Re: Dynamically Changing Y Axis : Clustered Column Chart

Chandrashekar — Tue, 16 May 2023 11:20:01 GMT

Hello,

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

Regards,

Chandrashekar B

Re: Dynamically Changing Y Axis : Clustered Column Chart

eliasayyy — Tue, 16 May 2023 12:09:25 GMT

ok can you please elaborate more

Re: Dynamically Changing Y Axis : Clustered Column Chart

Chandrashekar — Wed, 17 May 2023 04:11:10 GMT

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

Re: Dynamically Changing Y Axis : Clustered Column Chart

eliasayyy — Thu, 18 May 2023 06:17:37 GMT

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

Re: Dynamically Changing Y Axis : Clustered Column Chart

Chandrashekar — Thu, 18 May 2023 06:36:11 GMT

Hello,

Exactly and same should align to Y axis.

Regards,

Chandrashekar B

Re: Dynamically Changing Y Axis : Clustered Column Chart

Chandrashekar — Mon, 22 May 2023 03:45:54 GMT

Hello,

Can you please help me to get solution.

Regards,

Chandrashekar B

Re: Dynamically Changing Y Axis : Clustered Column Chart

Chandrashekar — Mon, 22 May 2023 03:47:28 GMT

Hello,

Can you please help me to get solution.

Regards,

Chandrashekar B