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 for me?

 

 

 

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

11 Replies

  • 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

    • Yuiitsu's avatar
      Yuiitsu
      Helper V
      3 years ago

      Sorry the blog doesnt seems to help what I am trying to do now.

      I am using Power BI Matrix 3.1.1 perhaps you can see how I can do the formatting for it?

       

      • Yuiitsu's avatar
        Yuiitsu
        Helper V
        3 years ago

        Also I think PowerBI has updated? I tried to follow the blog's but I dont see the same icons in my Powerbi desktop.

         

  • 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