Pivot Grid - show empty rows function

[MarcBasten]

Hi, i am trying to filter out empty rows and columns of my pivot grid. However clicking the button "show empty values on rows" etc. does not work for me. Any idea how to filter out all the empty rows and columns?

[otykier]

When I tested this just now using 3.13, it seems to work as expected. Pivot Grid on the right has "Show empty values on rows" enabled:

Could you share some more details on how your Pivot Grid is set up, and possibly the DAX expression making up the measure you're using?

[MarcBasten]

Hi Daniel, thanks for the fast reply! You were right. I was checking the base measures, which change empty values into '0' (as mgmt does not want to see empty fields). I guess if filtering zeros is not possible i have to add an extra measure for working with the pivot grid.

Again, thanks for the fast reply :)