Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

  • Anonymous,

     

    Click the caret (down arrow) for the field in matrix rows/columns, and select "Show items with no data":

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you!