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

     

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