Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I need help with my matrix table.
So, i have a table that haves the users on the lines, dates on the collumns and tasks on the cells.
As you can see here:
In this print im filtering the only to Month Mar Week 2 and i only can see 4 lines (users) because the others don't have any taks that week.
In this second print you can see that im already using the option "Show empy values" on owners (and also on all other fileds, not on Project Name because i don't have that option). In this print you can see that i've selected the next month and now i have one more owner:
I have two tables, the one with all the dates and the one with the tasks, the connection works fine:
So, basically what i need its to have all owners names even if they don't have any task for that week/month/day... Like it was always static showing always all the owners.
How can i make it?
Exemple of the desired result:
PS i don't mind if appears blank or "null" or "0" or something...
Thanks
Solved! Go to Solution.
Ok, so my own solution for this problem 😛
I've created a new table that haves all Owners/users and its connected to my Tasks table.
This way im able to have all users on the matrix even if they don't have anything on the lines.
thanks anyway!!!
Ok, so my own solution for this problem 😛
I've created a new table that haves all Owners/users and its connected to my Tasks table.
This way im able to have all users on the matrix even if they don't have anything on the lines.
thanks anyway!!!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 37 | |
| 35 | |
| 35 | |
| 28 |
| User | Count |
|---|---|
| 134 | |
| 101 | |
| 71 | |
| 67 | |
| 65 |