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?...
Need Help
  • 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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

Which calendar visual are you referring to?

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

 

Pete

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?