Forum Discussion
Dynamic KPI measure line
Hello everybody! I have a column based diagram, showing timelyness and target measure by months . In 2020 year target was 85%. In 2021 year it is 90%. How can I change my target measure, to see 85...
Hi , Anonymous
You only need to add a measure as below:
Target = SWITCH ( SELECTEDVALUE ( 'Table'[Date].[Year] ), 2020, 0.85, 2021, 0.9 )or
Target2 = VAR a = SELECTEDVALUE ( 'Table'[Date].[Year] ) RETURN IF ( a = 2020, 0.85, IF ( a >= 2021, 0.9 ) )
The result will show as below:Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak , unfortunately, I didn't catch, how should I change my measure "target"?