KPI STATUS in POWER KPI MATRIX

[aicirtap027]

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. 

[v-lili6-msft]

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]

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 · Accepted solution]

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

[aicirtap027]

Hello @v-lili6-msft,

How can I add a syntax into this formula, if there are blank data in the metric name it will not show on the table. My current situation is that when i tried to add the Color Status Measure in the KPI INDICATOR INDEX, it will show the metric name without data.

[v-lili6-msft]

hi, @aicirtap027 

Add a conditional as below:

Color Status =
IF ('Source Dump'[CLIENT VIEW]<>blank(),
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

[ahsankhan]

Dear Team, 

I am using Power KPI Matrix but I dont't need the KPI value to be shown in percentage. Is it possible to get it in absolute value, I have created a column calculating difference between current and target value, but still when i put it in the KPI value it shows the percentage. If it is not possible how can I just close the informaiton of percentage which is shown in the tooltip when i hover over the sparklines