Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 w...
Need Help
Tips and Tricks
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    1 year ago

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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

 

 

lbendlin's avatar
lbendlin
Super User
1 year ago


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