Forum Discussion
Solved
suppress zero value in matrix
Hi everybody! how we can suppress zero value in a calculated matrix column?
Aliafshari,
In the visual level filters of your visual, set the value of the measure to be not blank and not 0.
Regards,
Lydia
Hi lydia
Thanks for yoyre attention.
My matrix table is here and I would like to suppress the zero value, actually the red rows.
| MAINACCOUNTID | Site | Quantity | sum inventory amount |
| 1411101 | 1 | -1,438 | -36,623,716 |
| 1411101 | 2 | 39,574 | -14,109,014,584 |
| 1411101 | 3 | 2,032 | 138,402,199 |
| 1411101 | 4 | 273 | 273 |
| 1411201 | 1 | 0 | 0 |
| 1411201 | 2 | 0 | 0 |
| 1421101 | 2 | 13 | 3,743,660,542 |
| 1421101 | 3 | 14 | 14 |
| 1431101 | 1 | 265 | 14,096,138 |
| 1431101 | 2 | -1 | -681,882 |
| 1431201 | 1 | 0 | 0 |
Aliafshari,
In the visual level filters of your visual, set the value of the measure to be not blank and not 0.
Regards,
Lydia
Thanks Lydia