KPI Status using KPI Matrix

[MortenR]

Hi,

How do I add a green/yellow/red indication arrow on my KPI Matrix visual under the KPI Status-column in Power BI. I would like to see both the %-deviation and the arrow in the same column.

I have been watching various guides on how to do this the last 2-3 hours but find myself unable to understand these.

[leed · Accepted solution]

Hi @MortenR 

Measure 1 for the icon :

M_Magento_AverageOrderValue_YoY% =

DIVIDE ( [M_Magento_AverageOrderValue] - [M_Magento_AverageOrderValue_LY], [M_Magento_AverageOrderValue_LY] )

Measure 2 for the %+/- : 

M_Magento_AverageOrderValue YoY KPI =

IF (

NOT ISBLANK ( [M_Magento_AverageOrderValue_YoY%] ),

(

IF (

[M_Magento_AverageOrderValue_YoY%] < 0,

FORMAT ( [M_Magento_AverageOrderValue_YoY%], "Percent" ) & " "

& UNICHAR ( 129055 ),

"+" & FORMAT ( [M_Magento_AverageOrderValue_YoY%], "Percent" ) & " "

& UNICHAR ( 129053 )

)

),

BLANK ()

)

in the visual, add the Measure 2 by conditional formating by Rules based on field Measure 1:

Best,

DA