Forum Discussion
Solved
Help needed on Y axis
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
Hi Sander1401 ,
Try something similar to:
MAX value = CALCULATE (MAX(Table[Column]), ALLSELECTED(Table[Month]))
3 Replies
Hi Sander1401 ,
Try something similar to:
MAX value = CALCULATE (MAX(Table[Column]), ALLSELECTED(Table[Month]))Hi MFelix,
thanks for your reply, but what column should I add in the formula?MAX value = CALCULATE (MAX(Table[Column]), ALLSELECTED(Table[Month]))
The column that you want to use has maximum value
