Forum Discussion
Table visual as a calendar visual - differentiate two conditional formatting in a single cell
Hi everyone.
I have been attempting to create a calendar like visual using the table and conditional formatting and everything works until there are two different events on one day for one person. There are two events that could overlap but they need to be clearly shown when they do overlap. As shown by the red circle, this week should also somehow have red for the same person:
Taking the red circle, we could assume that the data looks like this:
| Full Name | Date | Event Count | Description | Colour |
| John Doe | 12/6/2023 | 1 | Engineering Support | Red |
| John Doe | 13/6/2023 | 1 | Engineering Support | Red |
| John Doe | 14/6/2023 | 1 | Engineering Support | Red |
| John Doe | 15/6/2023 | 1 | Engineering Support | Red |
| John Doe | 16/6/2023 | 1 | Engineering Support | Red |
| John Doe | 12/6/2023 | 1 | Sales Rota | Orange |
| John Doe | 13/6/2023 | 1 | Sales Rota | Orange |
| John Doe | 14/6/2023 | 1 | Sales Rota | Orange |
| John Doe | 15/6/2023 | 1 | Sales Rota | Orange |
| John Doe | 16/6/2023 | 1 | Sales Rota | Orange |
Anonymous , you have try something like
Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs
Your logic of color would be different
2 Replies
- amitchandak
Super User
Anonymous , you have try something like
Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs
Your logic of color would be different
amitchandak I ended up creating an additional measure to detect if there are 2 events on a day and then using an icon to make sure it's different. Then for anyone wondering what it means, a tooltip clarifies it.