Hi, longtime lurker, first time poster.
I'm pretty **bleep** at this and got stuck and hopefully some of you pros got a solution.
Example-.pbix is found here
Screenshot of data and matrix
My problem is that the matrix lists empty categories but I don't want to remove them completeley.
If we look at the data we see 517 tickets with "cat.1" set as "hardware.
Out of the 517 tickets, 8 of them are categorized as just "hardware" and no values in "cat2,3,4,5" and I don't want to miss out on that data.
But I have no use for 3 extra "levels" of 8 and would like to remove then, but I don't know how (filtering with "is not blank" doesn't work).
@Anonymous one thing is confusing, if you remove those 3 level with value 8, isn't it is going to mispresent, if someone manually add the number , it will be short by 8. seems to be misrepresentation of the data.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k I don't think so, when i was looking into this it seems that "cat.5" mirrors whatever value is on "cat.4" and backwards as long as the previous "cat" it's empty.
If i sum up everything that is "not one of the four 8's under Hardware" i get 509 tickets (marked in green).
Add 8 (marked in yellow) to that and i get my total of 517 tickets.
Like i said, I don't want to remove all the "blank rows", i just want to remove the ones who are duplicates (marked with a red X).
@Anonymous I see what you are saying, missed the duplicate part, so you still want to show one level there so that value 8 does show up.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous would this work?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
