Forum Discussion
Highlight dates in calendar table
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
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
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.
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