PowerBI - How to hide rows where results are all 0's

user_12031932 0
Viewed 25

I'm still very new to PowerBI and learning as I go.

I'm making a report for user permissions and want to hide the rows where someone has no permissions for a screen, where its all 0's but want to see the row if it as at least one '1' in it.

I've done some searching but can't find how to do it.

Here is an example

powerbi-desktop powerbi
1 Answers

If you use Blank instead of 0 this will happen automatically. Otherwise write a measure like

MaxValue = max('Table'[Column2]) + max('Table'[Column3]) + max('Table'[Column4])

And use it in a visual-level filter.

user_72977000
Related