Forum Discussion
Filtering columns in a matrix visual
This seems like it should be a really easy problem, but I'm really struggling to find a solution. I want to filter out all columns in a matrix visual if all rows are blank, excluding the INVENTORY row. I need to ignore the INVENTORY row as it will always have a value. Is there a DAX expresion that will allow me to filter out these columns?
| SOURCE TABLE | ||
| PRODUCTION ORDERS | INPUT ITEM | INPUT QTY |
| INVENTORY | INPUT ITEM 1 | 300 |
| INVENTORY | INPUT ITEM 2 | 50 |
| INVENTORY | INPUT ITEM 3 | 225 |
| INVENTORY | INPUT ITEM 4 | 110 |
| PROD 1 | INPUT ITEM 2 | -20 |
| PROD 1 | INPUT ITEM 3 | -100 |
| PROD 2 | INPUT ITEM 2 | -13 |
| PROD 2 | INPUT ITEM 4 | -50 |
| PROD 3 | INPUT ITEM 2 | -5 |
| PROD 3 | INPUT ITEM 3 | -200 |
| PROD 3 | INPUT ITEM 4 | -5 |
| POWER BI MATRIX | ||||
| PROUCTION ORDERS | INPUT ITEM 1 | INPUT ITEM 2 | INPUT ITEM 3 | INPUT ITEM 4 |
| INVENTORY | 300 | 50 | 225 | 110 |
| PROD 1 | -20 | -100 | ||
| PROD 2 | -13 | -50 | ||
| PROD 3 | -5 | -200 | -5 | |
| ^ HIDE ^ |
1 Reply
BradTheBald https://www.inkeysolutions.com/blogs/power-bi-hide-null-or-blank-values-in-matrix-visual/
BradTheBald if it helps you please mark as solutions.
