Forum Discussion
Anonymous
4 years agoNot applicable
Highlight dates in calendar table
Hello
I have the following table in Excel and i want to use Power BI to highlight the dates in a calendar visualization and show the name/s in that date cell. Is that possible and how to do this? Any help is much appreciated!!
| Name | From | Until |
| Lizui | 11/01/2022 | 21/01/2022 |
| Laufenburg | 02/01/2022 | 29/01/2022 |
| Tegalpapak | 22/01/2022 | 26/02/2022 |
| Ar Rabiyah | 05/02/2022 | 02/03/2022 |
| Bellegarde | 07/02/2022 | 14/03/2022 |
| Gangarampur | 17/03/2022 | 23/05/2022 |
Hi Anonymous ,
With that specific visual, I think you would just put [From] in 'Start date', [Until] in 'End date', and [Name] in 'Events'.
If you have another field in your table for Department, for example, you could put that into 'Event Group' to colour-code people in the same department.
Pete