Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional Formatting one cell based on another cell

Hello all!

 

Each of the fields in the 'Metrics' column has a respective range for acceptable and unacceptable values (which will be reflected in the adjacent column labeled 'Grand Totals')

 

I would like to apply conditional formatting to each cell in Grand Total based on the range respective to the specific 'Metric' in question. 

 

For example: 5 'Assault' incidents may be considered high (that value in the 'Grand Total' column would be red). This same number of incidents may be considered a low figure for 'Detector Wandings' (that value would then be green). 

 

Any help or feedback is greatly appreciated! :) 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

    You can consider to write a measure with switch function to check current metric and return correspond color, then enable conditional formatting background color based on measure fields value.

    Conditional formatting in tables

    After these, you can enable conditional formatting on second field with 'rule' mode based on its value.

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Anonymous wrote:

      Hi Anonymous ,

      You can consider to write a measure with switch function to check current metric and return correspond color, then enable conditional formatting background color based on measure fields value.

      Conditional formatting in tables

      After these, you can enable conditional formatting on second field with 'rule' mode based on its value.

      Regards,

      Xiaoxin Sheng

      Thank you for your response :) I am a total newbie (introduced to Power BI less than a month ago). Is there a tutorial available that you recommend explaining the execution of this Switch function?