0 values not filtering out in matrix?

[MM1001]

I have a matrix table with a date colums and a code for the rows. it has a value attached it and I have set it to filter out 0s

Abover you can see the filter I am using and some 0 values still staying behind, the top row only has one line showing 101 units in october in the raw data?

Any tips would be great 🙂 thanks

[MM1001 · Accepted solution]

Ensuring that my measure and the raw value are filtered to not include 0 solved the issue.

[Anonymous]

Hi @MM1001 ,

The reason some 0 values are still visible is because there is other data in the row that has not been filtered out; as long as there is one piece of data in a row, then the entire row is shown.

Therefore, you can create a measure that converts 0 values to blank values. You can refer to the following example.

This is my original data:

Create a measure.

Measure =
VAR _sum = SUM('Table'[Column4])
RETURN
IF(_sum = 0,BLANK(),_sum)

Put it into the matrix and leave both rows and columns unchecked show items with no data.

This way 0 values will be filtered out as blanks, more details can be found in the attachment.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Greg_Deckler]

@MM1001 Try switching your measure to be a decimal number with 10 decimal places and see if you are just getting very small values that are more than 0?

[MM1001]

Also just to add, there is only one line of data for this specific value of 101 in october, there are no lines with this specific code for any other months

[MM1001]

Unfortunatly not, they are all whole numbers to begin with in the excel data.

[Greg_Deckler]

@MM1001 Any way you can share a sample file?