March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
We have a contractor who has built the following weekly schedule using Excel and we would like to automate for them in Power BI.
Would there be a way to recreate this layout using Power BI? I've tried different visualizations, such as Matrix and the Calendar Visual through MAC Software, however, neither provides the same layout as the contractors Excel calendar. Thank you in advance!
Hi there,
You can recreate this by using the standard Matrix visual and some clever DAX. You can then use conditional formatting to color the occupied slots of your team.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
170 | |
145 | |
90 | |
67 | |
58 |