Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello!

Let me explain more clearly.

I'm telling about "target" measure. In 2020 it was 85% But from the beginning of 2021 it is 90%.

How can I change my measure to see 85% in 2020 and 90% in 2021 on this graph?

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

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.