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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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.

Top Solution Authors