Forum Discussion

Sander1401's avatar
Sander1401
Helper II
3 years ago
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...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi  Sander1401 ,

     

    Try something similar to:

     

    MAX value = CALCULATE (MAX(Table[Column]), ALLSELECTED(Table[Month]))
Sander1401's avatar
Sander1401
Helper II
3 years ago

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's avatar
MFelix
Super User
3 years ago

The column that you want to use has maximum value