Forum Discussion
Solved
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 th...
FOXYBARK Use a Complex Selector to filter out the unwanted rows. The Complex Selector - Microsoft Fabric Community
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.