Showing Blank Values as Zero - Problem with Slicer Interaction

[mstone3]

Hello - I have a basic matrix visual that looks like this:

Matrix 1

The measure I placed in the values well to produce this matrix is: 

Count of Year = COUNTA('Snapshots'[Year])

This matrix is also filtered by a slicer from a different column called [Year Type] that has two options: Fiscal Year and Calendar Year.  The slicer is set to 'Fiscal Year' and all is well - I can toggle between fiscal year and calendar year values using the slicer.  However,  I want to show blank values as zero.  So I modified the measure to:

Count of Year = COUNTA('Snapshots'[Year])+0

The resulting matrix is:

So, the new measure worked, but now the problem is that the matrix displays all of the calendar year values in addition to the fiscal year values, even though the slicer is set to fiscal year only.   It is still filtered because all of the calendar year values are zero, but I don't want all of the zero calendar year values to show if the filter is set to fiscal year - I only want to see fiscal year values.

Thanks so much for your help!

[v-piga-msft]

Hi @mstone3 ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @mstone3 ,

What about the measure below?

Count of Year =
IF ( COUNTA ( 'Snapshots'[Year] ) = 0, 0, COUNTA ( 'Snapshots'[Year] ) )

If you still need help, please share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry

[Anonymous]

Hi @mstone3 ,

May be solution in this post helps you.

https://community.powerbi.com/t5/Desktop/Display-zero-instead-of-blank-in-matrix/td-p/193745

you can create another table refrencing to your pay plan 

Thanks,

Tejaswi