Forum Discussion
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
5 Replies
Hi Anonymous ,
Which calendar visual are you referring to?
What type of data (dates, date ranges etc.) does it require to populate?
Pete
Hi BA_Pete ,
I am considering the Power BI visual calendar by MAQ software. I am not sure if this is the best choice for this purpose. But i would like to show a calendar by month or based on the time slicer, so for example, it could be from 15 January 2022 until 11 February 2022. The next step would be to highlight that date cell if it is within the range for that name based on the Excel table in the first post. The third step would be to add the name of that person to that highlighted date cell.
Also, is it possible to reverse the highlighted date cells?
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