Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How can I retain matrix table layout while using a filter or slicer

I have a matrix table that has numerous tasks as columns, but not all of them apply to everyone. So when I use a slicer it automatically removes all the tasks that are not associated with that particular project. Is there a way to show all of them with the blanks while using a filter/slicer visual?

 

This is the layout currently

 

 

This is with a slicer. Notice how it removes all the columns that do not apply to those jobs. I understand the logic behind the filtering, but I would like the table format to remain the same with all the empty cells. Is there a way to do that?