Highlight dates in calendar table

[Anonymous]

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

[BA_Pete]

Hi @Anonymous ,

Which calendar visual are you referring to?

What type of data (dates, date ranges etc.) does it require to populate?

Pete

[Anonymous]

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?

[BA_Pete · Accepted solution]

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

[Anonymous]

@BA_Pete Thanks for your help!

Just another question (please let me know if i should create a new topic for this) but it relates to the same table - how to do the reverse? So, display the same information in a calendar table but instead, highlight the opposite dates? I mean, all dates not shown in the range corresponding to each person. Thanks.

[BA_Pete]

Hi @Anonymous ,

I think you would need to create a list of all dates, join it with your employee dates table then, anywhere where a date had no employee against it, you would add "No one scheduled" as an event in another column (something like 'if [employee] = null then "No one scheduled" else null]). You could then filter on this value to leave only dates where no one was scheduled. You would then put your date column into the From field, and your new column in the Event field.

Pete