Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

KPI colour - Conditional Formatting

Hello,   I have built a few KPI cards as follows .. So.. It has a value coming out of a Measure (Can be percentage or value in Millions) and Goals coming out of a table containing all ...
Need Help
Show and Tell
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 

    You can Either select the Card and go to 

    Or create a DAX measure for the purpose

     

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello,

     

    Thanks..

    But How can I use this to set up the rules for all three colours?

    I tried to set up the same rules for all the three (good, neutral and bad colour)..

    Isnt this the same as acking it up with DAX?

     

    Thanks

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Create a measure that gives you the color based on the conditions as follows:

CF Goal = 
SWITCH(
    TRUE(),
    [Actual] >= .41 , "Green",
    [Actual] >= .31 , "Orange",
    "Red"
)


Select your KPI Visual then click each fx under Color Coding

Click on the  Format By and choose Field Value and under Based on, select your the Measure CF Goal

Repeat for all three colors.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

     

    Thanks..

    But How can I use this to set up the rules for all three colours?

    I tried to set up the same rules for all the three (good, neutral and bad colour)..

    Isnt this the same as acking it up with DAX?

     

    Thanks

    • Fowmy's avatar
      Fowmy
      Super User
      5 years ago

      Anonymous 
      The conditions are set up in the measure CF Goal. You need to select Format by field value and select the CF goal for BAsed on Field. Refer to my 3rd screenshot

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Yes.. but my question was different ..:)

         

        Anyways thanks for helping out