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. 

[v-nmadadi-msft]

Hi @FOXYBARK 

May I ask if you have resolved this issue with suggestions provided by @lbendlin , @Greg_Deckler ? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you. 

[lbendlin]

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

[Greg_Deckler · Accepted solution]

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

[FOXYBARK]

Thank you @Gregg. Initially, the examples seemed like foreign language but I took the simpliest of the Complex Selector examples and started there. I also had to remove the dashes where there was no values in my matrix. It worked. I don't know how it works since I didn't have to place the complex selector matrix anywhere. Great solution though.