Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Removes row with all 0

Hi Power Bi Community,   How do i remove the row with all 0. I have a matrix table which looks something like this: The data that I put for my matrix table is:   I've created a measure for...
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

I think the easiest way would be to drag your Measure to "Filters on This Visual", and then select Measure Hours is not 0.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, thanks for the reply but it will affect the other rows too. The "0" in my other rows would disappear and it will look like this: