Forum Discussion

markus_zhang's avatar
markus_zhang
Icon for Advocate III rankAdvocate 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
Icon for Community Champion rankCommunity Champion
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
Icon for Community Champion rankCommunity Champion
7 years ago

markus_zhang

 

And something else: it's also best to disable the Auto Date/Time option, of whose existence I had no clue until earlier today. Check out the odd behavior I came across recently and its solution in this post.