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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors