Forum Discussion
Removing Blank Row From the Matrix table
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 |
3 Replies
- amitchandak
Super User
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" ?
