Hello all,
I am trying to remove blanks from power BI matrix. Please see the below table:
| Type | 12.4.2023 | 13.4.2023 | 14.4.2023 | 15.4.2023 |
| Type A | | | | |
| SL1 received | | | 25 | 11 |
| SL1 expected | | | 100 | 40 |
| SL2 received | | | | |
| SL2 expected | | | | |
| SL3 received | | | | |
| SL3 expected | | | | |
| Type B | | | | |
| SL1 received | 20 | | | |
| SL1 expected | 20 | 2 | 10 | |
| SL2 received | | | | |
| SL2 expected | | | | |
| SL3 received | | | | |
| SL3 expected | | | | |
| Type C | | | | |
| SL1 received | | | | |
| SL1 expected | | | | |
| SL2 received | | | | |
| SL2 expected | | | | |
| SL3 received | | | 12 | 14 |
| SL3 expected | | | 15 | 20 |
The expected output is:
| Type | 12.4.2023 | 13.4.2023 | 14.4.2023 | 15.4.2023 |
| Type A | | | | |
| SL1 received | | | 25 | 11 |
| SL1 expected | | | 100 | 40 |
| Type B | | | | |
| SL1 received | 20 | | | |
| SL1 expected | 20 | 2 | 10 | |
| Type C | | | | |
| SL3 received | | | 12 | 14 |
| SL3 expected | | | 15 | 20 |
I have tried unchecking the row option from the visualization pane 'Show items with no data' . It removes the the entire type (A,B or C) only when there are no numbers in any of the measures. Using visual filters, hides the entire table incase a measure is empty for eg: SL2 received is empty, basically power BI hides that particular row, but the entire table gets hidden in the process. SL1 received, SL1 expected, SL2 received, SL2 expected, SL3 received and SL3 expected are all measures from measures table, They get differentiated by types by adding types into the ROW, dates in the COLUMN and measures in the VALUE in the power BI matrix visual. Any help regarding this please? Is there workaround for this using DAX or should we use any other type of power BI visual. The customer requirement is to remove any blank rows from the matrix.
