dynamically remove empty rows

[FOXYBARK]

Hello. 

Is there a way to remove my empty rows with no values? This matrix has a property slicer so the rows should disappear depending on what property is selected in the slicer. For example, in this picture, Meals, Amenity, etc should not show. I tried to do so a filter on this visual to keep values > $0. That did not work. Any ideas are appreciated. 

[lbendlin]

To hide a row in a matrix visual all the cell values in that row need to evaluate to BLANK()

[Greg_Deckler]

@FOXYBARK Use a Complex Selector to filter out the unwanted rows. The Complex Selector - Microsoft Fabric Community