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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.