Looking for 31-day timeline view

[ScottLawDev]

We have a team/group calendar which shows where employees are working each day. Today this is stored in M365 in a shared calendar, but we would be happy to move this off of M365 and into a custom database, SharePoint List, it doesn't really matter. We are more concerned with the visualization of this data and would like to know if this can be accomplished with Power BI Services. We plan to embed this report into a SharePoint web part eventually.

Here's a screenshot of what we are trying to achieve (mocked-up in MS Excel):

So the goal is to show a table where the columns represent a day-of-the-year in a (roughly) one-month timespan. The rows would be each employee. The cells would indicate via color and text the location where an employee will be working on that day, and adjacent cells with the same value (location) would merge to show a "band" of contiguous dates in the same location. 

I've tried to recreate using a Table and a Matrix but I have not been successful.  Any ideas if this is possible?  Thanks.

[ScottLawDev]

Thank you for the suggestion.  Would you be able to share any code snippets how you accomplished this?

[otravers]

It's funny that you ask as I just built a somewhat similar matrix for one of my clients (though without the "merge"). You could do something like this with a Matrix visual but you'll have to add some DAX logic to the measure so that it only displays text in the middle of the range, as well as use another measure for the color background (using expression-driven conditional formatting).