Forum Discussion
How to keep table structure after filtering data?
Hello everyone,
I'd like to know if it is possible to keep a matrix table structure (same columns, same rows) even after when I filter data and this filter I applied will not have values.
For example:
Let's say I have a list of products (P1, P2, P3) and I am looking at the "matrix table" view below but want to see only P1
If I filter ( in a slicer) P1 it has values on column "Feb" but it doesn't has values on the column "Gen" and "Mar"
In this scenario, Power BI will hide "Gen" and "Mar" and only show me the "Feb" (which has values).
I would like to know if there is a way of it showing the columns, but simply return zero.
Thank you 🙂
Anonymous,
Click the caret (down arrow) for the field in matrix rows/columns, and select "Show items with no data":
2 Replies
- DataInsightsSuper User
Anonymous,
Click the caret (down arrow) for the field in matrix rows/columns, and select "Show items with no data":
- AnonymousNot applicable
Thank you!