Table visual as a calendar visual - differentiate two conditional formatting in a single cell

[IssieWissie]

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

I've tried some things, but they have not worked. Any ideas as to how I could differentiate the cells for any days that have two events?

[amitchandak · Accepted solution]

@IssieWissie , you have try something like

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

Your logic of color would be different

[IssieWissie]

@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.