Forum Discussion
Conditional Formatting one cell based on another cell
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
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 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?
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