Skip to main content

Power BI

New

Matrix Row Total Hide Zero

Vote (26) Share
Anton's profile image

Anton on 19 May 2017 19:30:29

Hide Row when Row Total is Zero in Matrix Visual

Comments (1)
Anton's profile image Profile Picture

9ec20a6e beff-4832-b242-9622e9a8f891 on 05 Jul 2020 23:35:08

RE: Matrix Row Total Hide Zero

Really expected to see more votes on this one. There's another similar improvement idea for the same thing, but it's also low in votes. I currently have to build a custom measure to add all the potential columns in a matrix to give me a single filterable measure to get rid of rows with all zeros or blanks.

The downside of course is each visual might have a different set of columns that require a separate custom measure to filter with. I know this is available in QlikView so probably available in others as well.