Forum Discussion
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?
- Anonymous4 years ago
Anonymous , have you tried using the "Show items with no data" option?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
2 Replies
- AnonymousNot applicable
Anonymous , have you tried using the "Show items with no data" option?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data- AnonymousNot applicable
Anonymous thanks for the suggestions. It did work!