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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , Yuiitsu 

Based on your logic and requirements description, you want to implement in the matrix if the KPI status <95% shows a red down arrow, 95%- 100% shows a green check mark, > 100% shows an up arrow, I think you can achieve this requirement with the conditional format setting of the icon in the matrix:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

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

Yuiitsu's avatar
Yuiitsu
Helper V
3 years ago

Hi

 

I do not see this option 'Cell Element" in my Visual format.

 

Also i do not have a measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data.

This is the measure I am asking for help.

 

here is also a sample data of what I put into Power KPI matrix 3.1.1:

Business UnitSelling PriceBudget
GT4532451000000
YA25266000
LUM8575000
SSI85244900000
TOP6931165800

 

I also have a calculated measure for my margin 

BU Margin = SUM('FIN data FY50-70'[Profit])/SUM('FIN data FY50-70[Selling Price])
 
Please let me know if I can provide anymore data too!
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , Yuiitsu 

    I download the "Power KPI matrix" and see the sample .pbix file . The icon setting is used as the [KPI indicator] options:

    And put the column in it(1,2,3,...):

    So i think you need to add a column like this.

     

    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

    • Yuiitsu's avatar
      Yuiitsu
      Helper V
      3 years ago

      Yes I know I have to put add a column there so I am asking how to create a calculated column like that....

       

      I do not have a measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data.

      This is the measure I am asking for help.

       

      For example the file you ask me to download has this : 

      KPI Index = if(value([Variance])>= .05, 1, if(value([Variance])<-.05,3,2)) 

       

      ^ so what I am seeking help in is how can I make a measure to add a calculated column giving the specific condition I want the index.

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        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