highlight cell value based on color

[abukapsoun]

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,

[amitchandak]

@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 · Accepted solution]

@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

Attaching the pbix file for your reference.

[SweetsMum]

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?

It is not allowed me to select it.

[abukapsoun]

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!

[abukapsoun]

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?

[abukapsoun]

ive done it.

thanks

[abukapsoun]

@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,

[abukapsoun]

i was missing the # !!