suppress zero value in matrix

[Aliafshari]

Hi everybody!

how we can suppress zero value in a calculated matrix column? 

[v-yuezhe-msft]

@Aliafshari,

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,
Lydia

[Aliafshari]

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

[v-yuezhe-msft · Accepted solution]

@Aliafshari,

In the visual level filters of your visual, set  the value of the measure  to be not blank and not 0.


Regards,
Lydia

[Aliafshari]

Thanks Lydia

[Aliafshari]

Hi 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.