Help needed on Y axis

[Sander1401]

Hi all,

I have a visual with the possibillity to switch between absolute numbers and percentages (up to 100%).
The only problem I have is that sometimes the Y-axis shows 200%, so the bars only fill half.
That's why I want to construct a measure to put in the Y-axis max.
But I am stuck on the formula for the absolute numbers.
See below my example, I have a  stacked bar with months on the X-axis and legend on status, but I need a formula to calculate the max total per month, so in this case 450 (month 202203):

month	status	count	Total per month
202201	A	50
202201	B	100	200
202201	C	50
202202	A	100
202202	B	75	250
202202	C	75
202203	A	150
202203	B	200	450
202203	C	100
202204	A	100
202204	B	100	300
202204	C	100

Thanks in advance,

Sander

[MFelix · Accepted solution]

Hi  @Sander1401 ,

Try something similar to:

MAX value = CALCULATE (MAX(Table[Column]), ALLSELECTED(Table[Month]))

[Sander1401]

Hi MFelix,
thanks for your reply, but what column should I add in the formula?

MAX value = CALCULATE (MAX(Table[Column]), ALLSELECTED(Table[Month]))

[MFelix]

The column that you want to use has maximum value