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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
joaoantunes
Frequent Visitor

Matrix Table show lines without Data

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.

powerbi (1).PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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:

 

powerbi (2).PNG

 

I have two tables, the one with all the dates and the one with the tasks, the connection works fine:

powerbi (3).PNG

 

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:

powerbi4.jpg

 

PS i don't mind if appears blank or "null" or "0" or something...

 

Thanks

1 ACCEPTED SOLUTION
joaoantunes
Frequent Visitor

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!!!

View solution in original post

1 REPLY 1
joaoantunes
Frequent Visitor

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!!!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.