Gauge chart as a KPI

[mmv]

Hello everybody,

I am trying to create a dashboard with KPIs to measure goal achievement over the years. I have to use a gauge chart for this. I have a list of values for a specific KPI type and a year for the value:

I have a year filter in my visualization from which I can select the wished time frame:

and I would like to see the value of the selected end year (in this example 2023 --> value at gauge chart 86, or if it would be for example 2022 then value should be 131) accordingly. Unfortunately, I could not find a way to display it. 

Do you have any suggestions what could help?

[v-yangliu-msft · Accepted solution]

Hi  @mmv ,

As far as I know, the Gauge Visual value changes with the value selected in the slicer, in your picture it shows Between Slicer, so the value the dashboard is begging for is the value summed between 2019 and 2023.

You can check Gauge Visual -- Filter

Filter type – Top N

Show itmes – TOP 1

By value – [Year]

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.