Forum Discussion
Dynamically changing Y axis limit for cluster chart visual
Hi - I have created a custom chart having clustered, staked and line charts by combined 3 visual as shown in the below image. To aling all the 3 visuals, I have set the Y axis limit to 2000, a consta...
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.
MaxLimit =
VAR MaxValue =
MAX(
MAX(
[Total Created Ticket],
COUNT('Service IT Closed Tickets'[TicketNumber])
),
MAX(
[Backlog Carried Forward Count],
[Backlog Closed Count]
)
)
RETURN
MaxValue * 1.1
[Total Created Ticket] = Ticket created + Backlog carry forwarded
The Y axis maximum limit is exceeding the way beyond the total number of received tickets per month. I have an average of around 1800 tickets received per month, so I set the maximum limit as 2000 but it is not useful if I use filter values.
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.