Forum Discussion

em12340's avatar
em12340
Frequent Visitor
7 years ago
Solved

Background Color Change based upon Value

Hi PowerBi Community,   I have a matrix table that where the values are colour coded based on three categories Engagement, Known, and Outcomes, I am able to colour code the values but for the cells...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

     

     

    Hi,

     

    just make a new column with similar concept as explained below( you have to apply either if or switch function) :-

     

    I'm using IF condition/function

     

     New_Column = if([category = "engagement" , 1,
                                if(([category = "Known", 2,
                                    if(([category = "Outcomes", 3,0))

    Now go to condition backgroubd formating (click on field column in which you want to do background formatting)

    Please see the below picture

     

    Now in the conditional background formating use the new column to make the rules.

    Select Format BY to rules

    Select based on Field to New_Column

     

     

     

    YOU WILL GET SIMILAR RESULT AS BELOW:

     

     

    HOPE THIS WILL HELP

em12340's avatar
em12340
Frequent Visitor
7 years ago

that would work although i would want them to colour code in the category they are in, so for instance you can see "Auckland Regions" has some blanks and it comes under the category known,so i would want them to be colour coded orange. as you see in the picture below i have blanks for the category Engagements therefore , for all the blanks they should be coloured blue 

 

em12340's avatar
em12340
Frequent Visitor
7 years ago

or is there a way to just make everything under the Column "Engagement" blue and everythingunder the Column "Known" Orange and everything under the column "Known" Purple?