Forum Discussion
Dynamically changing Y axis limit for cluster chart visual
Hi hasarinfareeth ,
You can achieve your goal by this DAX:
MaxLimit =
VAR MaxValue =
MAX(
MAX(
[total received],
[Total Closed]
),
MAX(
[Carried Forward],
[Backlog closed]
)
)
RETURN
MaxValue * 1.1
Now select your chart and go to format pane, and in your Y-Axis select the fx to apply maximium limit:
Now the field should be based on the creatd measure:
Now your max will be dynamic and will be based on maximum of your measures increased in 10% (1.1).
Thank you very much Bibiano_Geraldo but this is not giving me an expected result as one of the value in the visual is a count of total rows.
Tried with the below.
- Anonymous1 year agoNot applicable
Hi hasarinfareeth, hello Bibiano_Geraldo, thank you for your prompt reply!
According to your screenshot, your chart only shows four key metrics, why does your MaxLimit calculation include values that are not part of the actual chart?
If possible, please upload the sample pbix file without any sensitive information for further troubleshooting.