I have a set of KPIs say (KPI1, KPI2, KPI3) with targets for each KPI each Month. Now If I build a simple line chart to show trend per month with the KPI expressions grouped in a cyclic button and then add another line chart expression for the target say Only(TargetKPI2), then how can I format the expression so that the target line changes whenever you choose a specific KPI? Is there a good syntax I can use?
