topic category and subcategory in matrix in Custom Visuals Development Discussion

category and subcategory in matrix

Piotr123 — Tue, 02 Sep 2025 08:59:17 GMT

In my table, not every index has a subcategory. How can I hide the empty rows in a matrix visual?

Re: category and subcategory in matrix

MasonMA — Tue, 02 Sep 2025 15:30:35 GMT

Hello Piotr123

The most straightforward way would be applying a filter on Subcategory level.

Re: category and subcategory in matrix

Piotr123 — Wed, 03 Sep 2025 06:18:19 GMT

Hello MasonMA,

Thank you for your response.

When I apply the filter this way, the Index data disappears. My goal is to keep all the data intact and remove only the empty subcategory headers.

Do you have any ideas how to achieve this?

Re: category and subcategory in matrix

MasonMA — Wed, 03 Sep 2025 12:17:30 GMT

Hello Piotr123

Then i would suggest using Minimal for Style, Tabular for Layout and disabling +/- icon under Row headers.

Re: category and subcategory in matrix

Piotr123 — Thu, 04 Sep 2025 07:10:35 GMT

Thank you

It seems this issue might be related to a ragged hierarchy, which could potentially be addressed using a DAX measure based on a parent-child hierarchy. However, I'm not entirely sure how to implement such DAX measure

Re: category and subcategory in matrix

MasonMA — Thu, 04 Sep 2025 12:33:06 GMT

Piotr123

Please show the expected layout in Excel so that other users can come up with a solution.