cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
em12340 Frequent Visitor
Frequent Visitor

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 that have no value dont get colour coded since they dont contain any data. Is there a way i can colour code them as well? Thanks in advance ! 

Capture4.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
GauravSingh Regular Visitor
Regular Visitor

Re: Background Color Change based upon Value

 

 

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

Capture 2.PNG

 

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

 

Capture 3.PNG

 

 

YOU WILL GET SIMILAR RESULT AS BELOW:

Capture 4.PNG

 

 

HOPE THIS WILL HELP

6 REPLIES 6
Super User
Super User

Re: Background Color Change based upon Value

@em12340  you should be able to do so, could you provide info how you are using backgroun colors now since there are many ways to do so, it will help to provide the solution.





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




em12340 Frequent Visitor
Frequent Visitor

Re: Background Color Change based upon Value

i have a measure written like this,

SWITCH(TRUE(), MAX(Engagement[Type]) = "Outcome",1,MAX(Engagement[Type]) = "Known",2,MAX(Engagement[Type]) = "Engagement",3)
and i wouldve asssumed this would have colour coloded all values under those cateogry, but wher there are blanks there is
no data so it doesnt colour code it , thats the problem i am having
Super User
Super User

Re: Background Color Change based upon Value

@em12340  may be add final condition when it is not any of those values

 

SWITCH(TRUE(), 
MAX(Engagement[Type]) = "Outcome",1,
MAX(Engagement[Type]) = "Known",2,
MAX(Engagement[Type]) = "Engagement",3,
4)




Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




em12340 Frequent Visitor
Frequent Visitor

Re: Background Color Change based upon Value

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 

 

Capture23.JPG

em12340 Frequent Visitor
Frequent Visitor

Re: Background Color Change based upon Value

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? 

Highlighted
GauravSingh Regular Visitor
Regular Visitor

Re: Background Color Change based upon Value

 

 

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

Capture 2.PNG

 

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

 

Capture 3.PNG

 

 

YOU WILL GET SIMILAR RESULT AS BELOW:

Capture 4.PNG

 

 

HOPE THIS WILL HELP