How to rename a blank value in a matrix row or column

[admin_xlsior]

Hi guys,

I creating a Matrix Visual, something like below : 

For which, the row listed my Resources name getting from my FactTables, which obviously has value in certain Quarter which spread column wise in that matrix.

I also have a different table, which is a Target Table, with data like this :

Year	Target
2019	50

which has no direct relation to my Fact table or my Resources dimension, the only relation is the Year connect to my Date dimension [Year]

Problem arise, when I add the Target to this matrix, it will display my whole Resources provided it has no record in my Fact Table. resulting the matrix shows many empty / blank rows.

How am I going to hide or remove this, so it will still display the Resources (or data) from my Fact table only.

Thanks in advance,

[v-xicai · Accepted solution]

Hi admin_xlsior,

You can select the matrix visual, and go to Visual Level Filter pane, do an advanced filter to choose "is not blank" to filter the blank rows out.

If you have any other issue, please feel free to ask.

Best Regards,

Amy