Forum Discussion
Resolver IHide Empty Rows/SubHeader in Matrix
Hi ptmuldoon
Your subheading doesn’t have a name but isn’t empty value. If empty, then it will be automatically removed from matrix visual.
To address this, you can assign a meaningful name using Power Query by replacing the empty value with a name. Alternatively, you can remove such categories using the basic filter option. If you don’t want any category, such as an empty name, simply check all and uncheck the desired one. This will hide all elements under this subheader. See the image below:Hope this helps!!
If this answer solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Super UserThat empty subheader is part of a hierarchy of columns in the context of your matrix viz. Removing that will remove the rows below it as well as they will not be automatically moved to where the empty subheader is. Your table probably looks like this:
If you remove blank SubCategory2, you will also remove the related rows from the other columns. If you don't want blank, either you fix that from the source or replace that with another value using M or a custom column that assigns a value to it relative to the values in the other columns.