Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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!!

 

NameFromUntil
Lizui11/01/202221/01/2022
Laufenburg02/01/202229/01/2022
Tegalpapak22/01/202226/02/2022
Ar Rabiyah05/02/202202/03/2022
Bellegarde07/02/202214/03/2022
Gangarampur17/03/202223/05/2022
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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