Conditional Formatting one cell based on another cell

[Anonymous]

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! 🙂 

[v-shex-msft]

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]

---

@v-shex-msft 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? 

[v-shex-msft · Accepted solution]

HI @Anonymous ,

Please take a look at following blogs to know more about switch functions:

DAX – Making the “Case” for SWITCH()

Optimizing IF and SWITCH expressions using variables

Please understand that these links are provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng