Forum Discussion
Solved
Adding traffic lights to indicate "Status"
Hi, lookign for soem advice regarding adding traffic lights to indicate status, i.e. red ="Overdue", Amber = "Due Soon" and Green = "In Progress".
Table uploaded is below.
Many thanks in advance.
| Task | Task Owner | Start Date | End Date | Project Heading | Task Due Status | |
| KH | 01/06/2024 | 27/06/2024 | GG Offer Changes | Overdue | ||
| IH | 01/07/2024 | 05/08/2024 | GG Offer Changes | In Progress | ||
| DD | 10/07/2024 | 12/07/2024 | GG Offer Changes | Due Soon | ||
| PW | 12/07/2024 | 01/08/2024 | GG Offer Changes | In Progress | ||
| KH | 10/07/2024 | 01/08/2024 | GG Offer Changes | In Progress | ||
| KH | 01/08/2024 | 01/09/2024 | GG Offer Changes | In Progress | ||
| IH | 15/08/2024 | 10/09/2024 | GG Offer Changes | In Progress |
try this:
pls see the attachment below
5 Replies
Looking at the condtional formatting text but cannto get it to work. Tried to enter the measure
StatusColour = SWITCH(('Sheet3'[Task Due Status],"Overdue", "Red", "Due Soon", "Amber", "In Progress", "Green"))though the Task Due Status isnt being recognised.try this:
pls see the attachment below
Hi, thanks, I think that will work but due to my version of Power BI I dont'appear to have the same options within the conditonal formatting as above. Thanks again for your help, greatly appreciated.
you are welcome. then it's better to upgrade your PBI version.
