Forum Discussion
dynamically remove empty rows
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.
FOXYBARK Use a Complex Selector to filter out the unwanted rows. The Complex Selector - Microsoft Fabric Community
4 Replies
To hide a row in a matrix visual all the cell values in that row need to evaluate to BLANK()
FOXYBARK Use a Complex Selector to filter out the unwanted rows. The Complex Selector - Microsoft Fabric Community
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.
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.
