Colour Table Cell by Text Value

[RachitBhatnagar]

I have created a calculated column in Power Bi Desktop in Table Visualization. The cell values in the columns contain Black, Blue and Red. I want to colour the cells based on these cell values present in the calculated column. I want Blue cell in the table to have Conditional Formating-> Background as Blue colour background and Red cell fields as Red colour background. How to solve this issue?

[RachitBhatnagar]

I have created a calculated column in Power Bi Desktop in Table Visualization. The cell values in the columns contain Black, Blue and Red. I want to colour the cells based on these cell values present in the calculated column.

I want Blue cell in the table to have Conditional Formating-> Background as Blue colour background and Red cell fields as Red colour background.

How to solve this issue?

[Anonymous · Accepted solution]

Hi @RachitBhatnagar

Create a measure like this:

color = MAXX(Table1,IF(Table1[Product]="Green",1,IF(Table1[Product]="Yellow",2)))

Then apply conditional format in your column using this measure:

 

Thanks

Raj