Forum Discussion

mimi's avatar
mimi
Advocate I
7 years ago

How to stop the table from reducing columns/rows

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

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      mimi
      Advocate I
      7 years ago

      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.

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        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