cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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?

3 REPLIES 3
Highlighted
Super User III
Super User III

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

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

Highlighted
Anonymous
Not applicable

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

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

Highlighted
Community Support
Community Support

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

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

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors