Forum Discussion

markus_zhang's avatar
markus_zhang
Advocate III
7 years ago
Solved

Slicer shows values in between

Hi experts, This is kind of strange, I have a date table with a list of dates, like: 2018-10-17 2018-10-24 ... But if I put a slicer on it, the slicer will give me ALL available dates, which is ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    markus_zhang

     

    I thought so. I've come across other types of problems cause by this. It is always better to create your own date tables. Additionally, if you don't mark them as date table Power BI Desktop will create its own date stuff in the background  and will cause problems sooner or later. Annoying problems that do not seem to make  any sense like what you were describing.  

AlB's avatar
AlB
Community Champion
7 years ago

Hi markus_zhang

 

Can you share the pbix? If necessary a version without confidential data that reproduces the problem? 

markus_zhang's avatar
markus_zhang
Advocate III
7 years ago

Hi @AIB thanks for the response. It does contain sensitive info so I can't share it.

But I think it's just the same for every PBIX file, no?

Basically I just created an Excel file and loaded the date column, here is the link:

 

https://www.dropbox.com/s/vmp7zp8venswkjc/Date.xlsb?dl=0

 

Then I tried to put the Date column on a slicer, and it just shows all days in between the values. I gave up and create a date column that has continous dates so I guess that's it.