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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
joef
Regular Visitor

Fabric Power BI Matrix report

I have a time reporting PBI matrix that I created in fabric.  Data is downloaded into fabric from the source daily at 5AM.

The report displays all hours entered for Support tickets for the cuurent week, our week starts on Saturday and ends on Friday.

The report is dynamically built by the data, example on Monday you will see you hours entered for saturday and  Sunday only.

the Matrix only shows days with hours so the table created only has those 2 days..

My question is:

Is there a way to have a table created at runtime to hold all 7 days, so every day the report will show as below?

AgentSaturday 2/15/25Sunday 2/16/25Monday 2/17/25Tuesday 2/18/25Wednesday 2/19/25Thursday 2/20/25Friday 2/21/25
tech 18500000
tech 25100000

 

TIA,

Joe

1 ACCEPTED SOLUTION

Not sure why you would want to do that as it goes against a whole list of design guidelines.  But here you are:

 

lbendlin_0-1739930478812.png

 

 

 

View solution in original post

7 REPLIES 7
lbendlin
Super User
Super User

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

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

AgentSaturday 2/15/25Sunday 2/16/25Monday 2/17/25Tuesday 2/18/25Wednesday 2/19/25Thursday 2/20/25Friday 2/21/25
tech 1007:300000
tech 203:007:000000
Tech 33:5508:000000
Tech 40012:000000

 

Data from Model

DeptAgentWordayDateTotalTimeTotalTimeSpentDayOfWeek
Dept1Tech1########7:307:3002/17/2025 Monday
Dept1Tech2########3:003:0002/16/2025 Sunday
Dept2tech3########3:553:5502/15/2025 Saturday
Dept1tech2########7:007:0002/17/2025 Monday
Dept2Tech3########8:008:0002/17/2025 Monday
Dept1tech4########12:0012:0002/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:

 

lbendlin_0-1739930478812.png

 

 

 

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.

 

joef_0-1739968195642.png

 


To report on things that are not there you need to use disconnected tables and/or crossjoins - like what I did in my example.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.