Forum Discussion
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?
| 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 | 8 | 5 | 0 | 0 | 0 | 0 | 0 |
| tech 2 | 5 | 1 | 0 | 0 | 0 | 0 | 0 |
TIA,
Joe
Not sure why you would want to do that as it goes against a whole list of design guidelines. But here you are:
7 Replies
what is your expected outcome?
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