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:
what is your expected outcome?
I am expecting a table as in my question.
agents down the rows
day/date acrosss the columns
when there are hours for a day to show up in the value(grid) else 0
Thx
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/1447523Here 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