Forum Discussion
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
5 Replies
Could you please share dummy data of your table and post expected result here? Do you want to show all values in Matrix that is greater than 0?
Regards,
LydiaHi Lydia Thanks for youre attention, my matrix table is here:
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 I must say that the sum inventory amount is a measure and the question is how to do not show the red rows.
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
