Hello Everyone, I am trying to track a list of rooms and wether or not they were cleaned on each day of the week. My two matrix visuals looks like this. As you can see the table on the left had no rooms cleaned on Monday, my goal is to have the table on the left show all days of the week wether any of the rooms were cleaned that day or not, and as a new user to power bi I am lost on how to address this. Thanks in advance, Alex

I was able to fix my problem, I needed to create 2 additional tables one with a list of rooms and one with the days in the week, and draw the relation ship from those tables to my data. Then use my newly created tables as my data for my matrix and when I selected show items with no data, it populated and now my problem is fixed. Thank you all for the help and responses.

Matrix Help | Microsoft Fabric Community

Forum Discussion

Related content

Matrix table

sorting matrix

Customize subtotal in matrix

Matrix formatting

Specific matrix