Forum Discussion

Yuiitsu's avatar
Yuiitsu
Helper V
3 years ago
Solved

Power KPI indicator Index

Hi all,   I wanna create a conditional formatting where by if KPI status <95% shows a red arrow down, 95%- 100% a green check mark and > 100% shows arrow up. Can anyone help create this measure fo...
Need Help
Tips and Tricks
Tutorial Requests
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi Yuiitsu 

     

    According to your current demand description, I can clearly understand your needs, you need measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data, You can use the Switch function in DAX to create the following metric value:

    Arrow =

SWITCH(

    TRUE(),

    [BU Margin]>=0&&[BU Margin]<=0.95,1,

    [BU Margin]>0.95&&[BU Margin]<=1,2,

    [BU Margin]>1,3)

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Select you visual, then click on "Format your visual" in the visualisation pane on the right of the screen.

Turn on "Cell elements>Icons", set the desired rules and select the icons you like the most.

  • Yuiitsu's avatar
    Yuiitsu
    Helper V
    3 years ago

    Hi Anonymous 

     

    Sorry can you direct me with some screenshots? Because I do not see any of the options that you mentioned on your post.

    I am using Power KPI Matrix 3.1.1