Forum Discussion

aicirtap027's avatar
aicirtap027
Frequent Visitor
7 years ago
Solved

KPI STATUS in POWER KPI MATRIX

Hi All,

 

I have a table with two comparison value and current value column, i want to show at the KPI STATUS column a conditional formatting. For example my Expected Target is 98% and my Minimum Target is 95%, my current value is 99.67% then my KPI Status will show a green circle which represents that the current value passed the expected target and minimum target. If the current value is 94% then KPI Status will show a red circle and if the current value is 95% then KPI Status will show a yellow circle which says that the current value passed the minimum target. Please help me on how can i create this kind of conditional formatting inside the power kpi matrix visualization. 

 

Need Help
Show and Tell
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, aicirtap027 

    For your  current value comes also from a measure, so you couldn't use SUM('Source Dump'[CLIENT VIEW]) 

    Just try this formula

    Color Status =
IF (
    'Source Dump'[CLIENT VIEW] > SUM ( 'Sheet1 (2)'[Exp Target] ),
    1,
    IF (
        'Source Dump'[CLIENT VIEW] < SUM ( 'Sheet (2)'[Min Target] ),
        2,
        IF ( 'Source Dump'[CLIENT VIEW] >= SUM ( 'Sheet (2)'[Min Target] ), 3 )
    )
)

    Best Regards,

    Lin

     

6 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, aicirtap027 

    Create a measure as blow:

     

    Color Status = IF(SUM('Table'[Current])>SUM('Table'[Expected]),1,IF(SUM('Table'[Current])<SUM('Table'[Minmum]),2,IF(SUM('Table'[Current])>=SUM('Table'[Minmum]),3)))

    Then drag it into KPI Indicator Index value

    Now set conditional color in Formatting->KPI Indicator as below:

     

     

    Best Regards,

    Lin

    • aicirtap027's avatar
      aicirtap027
      Frequent Visitor
      7 years ago

      Hello v-lili6-msft 

      I encountered error while creating this measure, my current value comes also from a measure. Please help me to correct my syntax. 

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        HI, aicirtap027 

        For your  current value comes also from a measure, so you couldn't use SUM('Source Dump'[CLIENT VIEW]) 

        Just try this formula

        Color Status =
IF (
    'Source Dump'[CLIENT VIEW] > SUM ( 'Sheet1 (2)'[Exp Target] ),
    1,
    IF (
        'Source Dump'[CLIENT VIEW] < SUM ( 'Sheet (2)'[Min Target] ),
        2,
        IF ( 'Source Dump'[CLIENT VIEW] >= SUM ( 'Sheet (2)'[Min Target] ), 3 )
    )
)

        Best Regards,

        Lin