I want to set dynamic targets to a gauge chart.
I have the target data stored in a table for multiple KPIs
In my expression I want to retrieve a Target for a specific KPI. e.g.
IF(KPI='MeasureA', SUM(Target),0) If I add KPI as a filter and select MeasureA it returns the value I'm looking for.
I want to hard code the selection of the measure in this case and store as a master item for use in other charts and display multiple KPIs on the same page.