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

RachitBhatnagar's avatar
RachitBhatnagar
New Member
8 years ago

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?