Forum Discussion
Solved
How do I remove rows from a matrix visual if the values are zero?
I would like to exclude those lines from my matrix visual where the monthly balance is zero (aka dormant accounts).
Dan_at_TWE If it is a measure, you should just be able to filter those out in the Filters pane. Or in you measure you could add a check that if 0, return BLANK().
3 Replies
Dan_at_TWE If it is a measure, you should just be able to filter those out in the Filters pane. Or in you measure you could add a check that if 0, return BLANK().
First one worked. Don't know right off which value to grab for the filter. Thanks.
Oh.... I have your "Learn Power BI" book in my house. Obviously, not used enough. That thing is huge! LOL!
