Forum Discussion

AMcMasterSage's avatar
AMcMasterSage
New Member
4 years ago
Solved

Conditional formatting with text

Hi All, I'm very new to using PowerBI so I may need a 'For Dummies' explanation here, but essentially what I'm trying to do is a traffic light status for the below pictured table;   Th...
Need Help
Tutorial Requests
  • jaideepnema's avatar
    jaideepnema
    4 years ago

    Hi AMcMasterSage ,

    Create a calculated column like this:

    Status = SWITCH(TRUE(),

    Data[Canada]="Approved by FD" && Data[France]="Approved by FD" && Data[Germany]="Approved by FD" && Data[Portugal]="Approved by FD" &&Data[South Africa]="Approved by FD" && Data[Spain ]="Approved by FD" &&Data[USA]="Approved by FD" &&Data[UK]="Approved by FD",1,

    Data[Canada]="Not Started" && Data[France]="Not Started" && Data[Germany]="Not Started" && Data[Portugal]="Not Started" &&Data[South Africa]="Not Started" && Data[Spain ]="Not Started" &&Data[USA]="Not Started" &&Data[UK]="Not Started",2,

    3)
    And apply conditional formatting on this column as shown below:

     

    This will give you the expected output:

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ğŸ˜€

     
jaideepnema's avatar
jaideepnema
Solution Sage
4 years ago

Hi AMcMasterSage ,

Create a calculated column like this:

Status = SWITCH(TRUE(),

Data[Canada]="Approved by FD" && Data[France]="Approved by FD" && Data[Germany]="Approved by FD" && Data[Portugal]="Approved by FD" &&Data[South Africa]="Approved by FD" && Data[Spain ]="Approved by FD" &&Data[USA]="Approved by FD" &&Data[UK]="Approved by FD",1,

Data[Canada]="Not Started" && Data[France]="Not Started" && Data[Germany]="Not Started" && Data[Portugal]="Not Started" &&Data[South Africa]="Not Started" && Data[Spain ]="Not Started" &&Data[USA]="Not Started" &&Data[UK]="Not Started",2,

3)
And apply conditional formatting on this column as shown below:

 

This will give you the expected output:

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos ğŸ˜€

 
Jhadur's avatar
Jhadur
Helper I
2 years ago

jaideepnema I am looking for a similar solution but I need it to be OR not AND. How would this be changed to use an OR statement? I modified the above for my columns but if the first cell is not Y or N then the conditional formatting doesn't apply to the whole row.