Forum Discussion
Slicer shows values in between
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.
An additional question, sorry, maybe I should use another post but I think it's related.
Say I have a column that contains dates from 2018-10-17 to 2019-01-16, and I put it into a Matrix, why does Power BI automatically expands the dates to full year of 2018 and 2019? I feel like it's the same issue, and this time it's even worse because I can't filter out those unneccesary dates prior to 2018-10-17 and post to 2019-01-16.
I must did it the wrong way I guess, becasue it's such a basic functionality.
FIGURED OUT!
Actually I need to set it as a date table and suddenly all other dates are gone! Such unnatural requirement... I just don't get the meaning of it...who on earth would need this anti-feature?
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.
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.