Forum Discussion
0 values not filtering out in matrix?
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
Ensuring that my measure and the raw value are filtered to not include 0 solved the issue.
6 Replies
- Greg_Deckler
Community Champion
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?
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?
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
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.
Ensuring that my measure and the raw value are filtered to not include 0 solved the issue.
