Not showing zero values when date filter applied

[aTChris]

Can anyone think of a reason why a datetime filter applied to a report causes a visualisation not to show zero values?

A have a table showing monthly contract revenue (vales) by asset (rows)  by month (columns). Some assets are new so dont have any contracted revenue to show yet. If I apply a datetime filter on the report or page to show data for present day onwards i.e. remove old information I lose any assets from the tables that has zero values.

I first thought that it was because I removed blank values, however found that it was in fact as soon as I apply any kind of filter by date.

[aTChris · Accepted solution]

Thanks @vanessafvg @V-lianl-msft 

After refectoring the report I cant repliacte it, I dont know exactly what it was im only guessing some over elaborate relashionships.

[V-lianl-msft]

Hi @aTChris ,

Please check if this option is checked

If the problem persists,could you please share the sample pbix or screenshot?(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

Hi Chris

can you supply some data, or give examples of what you saying

ie.

1. what does your data look 

2. what is your code

3. can you provide an example?