Removing Blank Row From the Matrix table

[Anonymous]

Hi, 

I would like to remove blank row from the Matrix Table. The challange i have is the table data is from two different database. Please suggest me if I can use any dax to hide the blank row. Below is an example of my dataset. I would like to remove the line with the subcategory tomato as there is no data.

Matrix Table
		Database 1	Database 2
Category	Sub Category	Metric 1	Metric 2	Metric 3
Fruits	Apple		30	10
Fruits	Orange	100	5	20
Vegetable	Tomato
Vegetable	Broccoli	40	5
Vegetable	Potato	60	3	50

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

You can just add in Visual Filters of that Visual, as "is not blank".

That would satisy your requirement. 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Ideally speaking, a blank row should not come, Have you handled blank value in Metric 1, Metric 2 or Metric 3?

Or have used option "Show Item with no data" ?

[Anonymous]

Show items with no data isn't working. Those are measures and database value's.