Forum Discussion
Fabric Power BI Matrix report
Not sure why you would want to do that as it goes against a whole list of design guidelines. But here you are:
Here is data from the view that drives the model for this week.
TotalTimeSpent is converted TotalTime from varchar to time so I can have a total for the each tech
WorkdayDate is only date of DayOfWeek (not sure why column isn't big enough to display)
Since today is Tuesday, I would expect the report to have as in my original question, having the time showing correctly for Sat, Sun, Mon, and 0 populated in Tue, Wed, Thur,Fri
Thank you for your help!!!!
REPORT OUTPUT
| Agent | Saturday 2/15/25 | Sunday 2/16/25 | Monday 2/17/25 | Tuesday 2/18/25 | Wednesday 2/19/25 | Thursday 2/20/25 | Friday 2/21/25 |
| tech 1 | 0 | 0 | 7:30 | 0 | 0 | 0 | 0 |
| tech 2 | 0 | 3:00 | 7:00 | 0 | 0 | 0 | 0 |
| Tech 3 | 3:55 | 0 | 8:00 | 0 | 0 | 0 | 0 |
| Tech 4 | 0 | 0 | 12:00 | 0 | 0 | 0 | 0 |
Data from Model
| Dept | Agent | WordayDate | TotalTime | TotalTimeSpent | DayOfWeek |
| Dept1 | Tech1 | ######## | 7:30 | 7:30 | 02/17/2025 Monday |
| Dept1 | Tech2 | ######## | 3:00 | 3:00 | 02/16/2025 Sunday |
| Dept2 | tech3 | ######## | 3:55 | 3:55 | 02/15/2025 Saturday |
| Dept1 | tech2 | ######## | 7:00 | 7:00 | 02/17/2025 Monday |
| Dept2 | Tech3 | ######## | 8:00 | 8:00 | 02/17/2025 Monday |
| Dept1 | tech4 | ######## | 12:00 | 12:00 | 02/17/2025 Monday |
Not sure why you would want to do that as it goes against a whole list of design guidelines. But here you are:
Hi,
Thank you for the help I will check out your solution.
I am brand new to Fabric and PBI. I am a SQL DBA and only used SSRS for the past 30 years, so I am not aware of design guidlines of PBI.
I am loking for trainng, but most of what I am finding is very old and seems stale, I am sure PBI has changed a lot in the past 2-3 years.
The reason for this design is, if there are no hours for a day, that day will not show on the report which can cause confusion. As you can see below, IT is missing Sunday, and Eng is missing Saturday. At a quick glance it looks good, but if an IT tech forgot to add Sunday, they may not notice, but they would notice a 0 or a blank for the day.
To report on things that are not there you need to use disconnected tables and/or crossjoins - like what I did in my example.