Hide empty rows in Matrix

Question

Hi there,&nbsp;So my question is fairly simple.I have added a Row to a Matrix that does not always contain a value, however it still shows up?How can I hide it, if it's empty/blank/null?Best regards&nbsp;

allisonkennedy · Answer

Shamatix&nbsp; You can add a filter to 'filters on this visual' for the same field that is in the rows of the matrix to exclude blanks values.&nbsp;

&nbsp;
Is that what you're asking?

shamatix · Answer

Hi,&nbsp;Thanks for your answer, but not exactly.If I do that it removes all the rows above/below (both green/red below gets removed if I do your suggestion)I want to keep the green rows and only remove the red.

allisonkennedy · Answer

Shamatix&nbsp; You can't keep the red without removing the green below it - unless you move the green below it into a category. Are you using multiple tables? You could replace the blank with another value, but if the blank comes from relationships you'll need to append a new row to the dim table:&nbsp;https://excelwithallison.blogspot.com/2020/07/what-does-this-blank-mean.html&nbsp;

shamatix · Answer

If I do not add the "row" I get this result which is how I want it to be if the rows im trying to add now is empty:&nbsp;However when I add the row and it's empty I get the below result instead?&nbsp;I hope that made more sense

allisonkennedy · Answer

Shamatix&nbsp; When you say if you do not add the row, I assume you are meaning that you are adding a field to the 'Rows' section of the matrix visual. Is this field coming from the same table as the field below it in the 'Rows' section? Does this field have blank values sometimes?&nbsp;
&nbsp;
You may be able to look into using the PATH function or doing a pivot or duplicate of your data to transform the tables to cheat the system, but the default behaviour won't allow it.
&nbsp;
Can you share a sample report or describe/screenshot your data model please?
&nbsp;
&nbsp;

Forum Discussion

Hide empty rows in Matrix

9 Replies

Related content

Remove/Hide Blank/Empty Columns in Matrix

Hide empty niveau in a matrix without losing underlying niveau's rows

PowerBI - Matrix table, hide values used only for a visual calculation

Matrix table column Hide

How to Hide empty Columns in Matrix visual?