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:
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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.