CODEWITHSUNDEEP
powerbipowerbi-desktop
lezs76
lezs76

Reputation: 59

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

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

Upvotes: 1

Views: 2592

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 88996

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.

Upvotes: 1

Related Questions