Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
abukapsoun
Post Patron
Post Patron

highlight cell value based on color

Hi 

 

I have a table as visual in powerBI. i would like to apply some colors if a cell value in a certain column equals to something.

for example if cell value = 2 then highglihgt the cell with red

if cell value = 4 highlight it with blue

 

I tried to apply the following

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#:~:tex....

 

But it did not work

 

I applied this formula to create a new column

Table.AddColumn(#"Unpivotted","test", each if [P08 Evaluation] ="Attention to Cost" then "#198c19" else "#a500ff")

 

Then I formatted my column based on this newly created column

 

here is the error I am getting,

abukapsoun_0-1599910900900.png

 

 

1 ACCEPTED SOLUTION
nandukrishnavs
Super User
Super User

@abukapsoun 

 

You have to create a measure and use that measure in the field format option.

 

Example:

DAX measure

Color = 
var _cellvalue= SELECTEDVALUE('Table'[LastTransaction])
var _color= IF(_cellvalue="No","#198c19","#a500ff")
return _color

nandukrishnavs_0-1599911490464.png

nandukrishnavs_1-1599911513865.png

 

 

Attaching the pbix file for your reference.

 


Regards,
Nandu Krishna

View solution in original post

8 REPLIES 8
amitchandak
Super User
Super User

@abukapsoun , if you have given column in a field value, It might have asked for Aggregation, Make sure it should be Min or Max

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
nandukrishnavs
Super User
Super User

@abukapsoun 

 

You have to create a measure and use that measure in the field format option.

 

Example:

DAX measure

Color = 
var _cellvalue= SELECTEDVALUE('Table'[LastTransaction])
var _color= IF(_cellvalue="No","#198c19","#a500ff")
return _color

nandukrishnavs_0-1599911490464.png

nandukrishnavs_1-1599911513865.png

 

 

Attaching the pbix file for your reference.

 


Regards,
Nandu Krishna

Hi,

Thanks for your solution.

I am trying to use your solution but it is failed when I want to select the measure "color".

I am using one dataset for my visual. Is it the reason?

SweetsMum_0-1670229377027.png

It is not allowed me to select it.

SweetsMum_1-1670229531261.png

 

It worked like charm!! Thanks you very very very much. 

 

And last thing, is it possible to have a button or a slicer dropdown (yes & no) in the report, if yes is selected, this conditional formatting will be applied, and if no, then nothing?

 

Thanks again!

 

I was thinking if we can create a column with yes and no value. and then extend the IF formula, by saying if colum1 = no then color would be white. and if value = yes then we apply another if to evaluate which color to display. How can we do that with formula?

 

ive done it.

thanks

 

@nandukrishnavs

 

Color =
var _cellvalue = SELECTEDVALUE(Pivotted[P08 Evaluation])
var _yesno = SELECTEDVALUE(YesNo[Evaluate])
var _color = IF(_yesno="No","f00000",IF(_cellvalue="Attention to Cost","#ff0000",IF(_cellvalue="Attention to Sales","#ff0000")))
return _color
 
 
I have a dropdown slicer with the "evaluate" column. When Yes is selected the color ff000000 appears,
When I select No the same below error appears, "we found a value we dont recognize for background"
 
Thanks,
 
 

 

 

 

 

i was missing the # !!

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.