Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ScottLawDev
Frequent Visitor

Looking for 31-day timeline view

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):

 

ScottLawDev_1-1661798866104.png

 

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.

 

2 REPLIES 2
ScottLawDev
Frequent Visitor

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

otravers
Community Champion
Community Champion

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).

otravers_0-1661802471186.png

 

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors