How to stop the table from reducing columns/rows

[mimi]

When I filter, the table reduces the number of columns/rows. I do not want that. How can I solve this? For example, when I filter by different customers the rows change. i want them to be the same so that i can spot blanks

[Anonymous]

Add this to the end of your measure:

+ 0

Power BI, like pivot tables, suppress blank values from being shown.  Zero is not the same as blank, and this will force a value to be shown in a visual.

[mimi]

Hi

Thanks for replying. The table was not made up of measures but columns that I dragged into the table. So that means I have to create a measure called Sales and add a zero. That seems to work.

Is there another way of showing zero or nulls without creating an additional measure.

[Anonymous]

@mimi , you should ALWAYS make measures, even for a simple SUM().  This is best practice, and all medium to advanced DAX depends on this EXPLICIT measures being created.  

[v-juanli-msft]

Hi @mimi 

Based on my knowledge, reducing rows for a table visual when filtering data is a default design.

Adding a measure is a simple workaround.

I have another workaround by create a new table and a measure.

If your are interested, please let me know.

If ChrisHaas's suggestion really help you, could you kindly accept his suggestion as a solution so more users can find this thread quickly?

Best Regards

Maggie