Forum Discussion

ladeko's avatar
ladeko
Regular Visitor
2 years ago

Help creating an IF statement with MULTIPLE CONDITIONS and CONDITIONAL FORMATTING

I have a Power BI dashbaord report that I use to do auditing. I would like specific columns inside the table to automatically highlight in yellow if certain conditions are met.  My tables column A has 4 different selections.  Therefore, if Column A meets condition A, OR condition B OR condition C OR condition D, then columns B, C, D, E and F CANNOT be blank and if they ARE blank, I want these columns to be highlighted in yellow. 

 

TABLE NAME = Investigations

 

Column A Name = Role In Incident

Column A conditions/options are:

  • Root Cause Associate
  • Root Cause Vendor
  • Root Cause Business
  • Root Cause Employer

Column B = First Name

Column C = Last Name

Column D = Department Name

Column E = Supervisor First Name

Column F = Supervisor Last Name

 

Therefore if Column A meets any of the above 4 conditions then columns B, C, D, E and F CANNOT be blank. If they are blank then I want it to highlight the column in yellow that is blank.

1 Reply