Visual works only for records in the year 2020 while using a slicer

[Gertjan_23]

I have a problem with my table visual. Something strange happens when displaying data in a table along with using a date filter. I use a table and date slicer where the year and month are a separate filter.

When I filter the year on 2020 I get the correct data of records in 2020, but when I switch to 2019 the table remains blank. The same is true for 2018. The funny thing is that the data is available in the dataset. There are no other visuals that affect the display. There are also no overarching filters in 'Filter'.

What could be possible causes for this problem?

[v-xuding-msft]

Hi @Gertjan_23 ,

Do you use a measure? Or is the data from the different tables? Can you please share the formulas that you used, the  relationships among the tables and something else like sample data and expected results?

Please see this post regarding How to Get Your Question Answered Quickly: 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Can you please paste some screenshots and the structure of your model? You might have stumbled across an issue with auto-exist, especially if you don't have a proper calendar in your model.

Best
D

[HotChilli]

Do you want to link your pbix because otherwise it is just guessing to try and answer this?

Please make sure the data is not confidential