Require Dynamic y-axis for both the graphs once i select any value from my slicer

[Shahashesh]

Hi All,

Requirement is to get dynamically y-axis once i select any value from my slicer.

Currently it is kept as 2k but my value in 2022 le graph showing value as 477.7 but graph shows around 2k which is incorrect.

There are different values for different KPI Category in my data. Tried to keep it in auto mode but it is not giving correct results. Can you please help in achieving it. Thanks!

Regards,

Ashesh Shah

[amitchandak]

@Shahashesh , Check if field parameters can help

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Shahashesh]

Hi @amitchandak

There are 4 charts in my pbi page. I have "KPI Category" as a slicer which contains multiple KPI's and different values for each KPI's. Here my requirement is if i select any KPI from slicer all the 4 graphs should dynamically change Y-axis Start and end based on the values it has on the graph for that selection. Am i making more sense now.

For eg. In the above snapshot i have selected "Total" in KPI category, 2022 le graph is having value as 477.7 which ideally should come below 500 range in y-axis but it is displaying around 1700-1800 as shown which is incorrect. Also all the values are different for each KPI category.

[Shahashesh]

Hi,

Can anyone please help in achieving this requirement