Skip to main content
Microsoft Idea

Power BI

Needs Votes

Matrix Row Total Hide Zero

Vote (27) 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

Ken Skinner 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.