Forum Discussion

rwong1's avatar
rwong1
Helper III
3 years ago
Solved

Color Formatting Table Entire row

Hi,   I need to do conditional coloring based on the sales stage.  For example, final committee review and due diligence will be red, term sheet negotiation will be yellow, and collecting informati...
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Hi rwong1 ,

     

    Create a measure as below and use it conditional formating for all the columns.

    _conditional_color = SWITCH(TRUE(),
MAX('Table'[Sales Stage]) = "Due Diligence","red",
MAX('Table'[Sales Stage]) = "Term Sheet Negotiation","Yellow",
MAX('Table'[Sales Stage]) = "Collecting Information","Green")

     

    Refer a file below:-

     

Samarth_18's avatar
Samarth_18
Community Champion
3 years ago

Hi rwong1 ,

 

Create a measure as below and use it conditional formating for all the columns.

_conditional_color = SWITCH(TRUE(),
MAX('Table'[Sales Stage]) = "Due Diligence","red",
MAX('Table'[Sales Stage]) = "Term Sheet Negotiation","Yellow",
MAX('Table'[Sales Stage]) = "Collecting Information","Green")

 

Refer a file below:-