Forum Discussion

RachitBhatnagar's avatar
RachitBhatnagar
New Member
8 years ago
Solved

Colour Table Cell by Text Value

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 presen...
  • Anonymous's avatar
    Anonymous
    8 years ago

     

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

 

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