Monthly zeros not showing in Matrix

[Nick2358]

Hello everyone, 

I have this small issue where we are showing different categories of numbers in a matrix.

I have a matrix whose category only has zeros but I need to see them anyway for each month:

January - February - March ...

    0              0                0

However when I apply my filters for this specific category it just shows the word "Month" and the name of my measure in the other column (and no numbers below):

Month - Name of Measure

Please note that my 0 are not blanks in my dataset. They are actually zeros.

Is there any way I can see these zeros in my matrix?

Thanks in advance,

Nick

[themistoklis · Accepted solution]

therefore, for the columns you have in the table (not the measure)... you have selected the ' option. Show items without data?

[themistoklis]

@Nick2358 

Have you tried selecting on the column 'Show items with no data'??

[Nick2358]

Hi @themistoklis,

I thought about it but it doesn't show in my column menu. It's actually a measure and not a column from the table I guess that's why. 

So I was wondering if there was another solution?

Thanks,

Nick

[themistoklis]

are the values shown as blank in the table or zeros?

If they are shown as blank try to replace them with zeros... e.g. by adding zero at the end of the formula

[Nick2358]

@themistoklis that's the thing I thought it was showing as blanks but it's already showing as zeros ...

[themistoklis · Accepted solution]

therefore, for the columns you have in the table (not the measure)... you have selected the ' option. Show items without data?

[Nick2358]

@themistoklis Oh right, it worked with my date column I can now see each month. 

However I have blanks instead of zeros ... but it's zeros in my table

Thanks,

[themistoklis · Accepted solution]

@Nick2358 

try replacing the blank values with zeros using any of the options below

1. Measure = CALCULATE ( SUM (table[column] ), FILTER (... ) ) + 0 (Add Zero at the end of the formula)

2. Measure = IF ( ISBLANK([Amount]), 0, [Amount])

3. Measure = IF (CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (), 0, CALCULATE ( SUM ( Expenses[Actual] ) ) )

[Nick2358]

@themistoklis first measure worked.

Thanks a lot for your help!

Thanks,

Nick,