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 T...
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

     

aicirtap027's avatar
aicirtap027
Frequent Visitor
7 years ago

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's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
    ahsankhan
    Icon for Helper I rankHelper I
    6 years ago

    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