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 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'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

2 Replies

  • 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

  • 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?