Forum Discussion
Date filter doesn't work properly
Hi,
I am new to PowerBI and I encounter a problem when I want to filter my report on a date.
If I use a slicer with a "between" everything works just fine (see pictures).
But when I use the slicer with a "list" and I select a date from the list Power BI shows nothing.
I don't know why this is happening. The format of my date column is datetime so this is not the problem I think.
Can somebody help me with this, or give an explanation why this won't work?
I work with PowerBI service and not with the Desktop version. If possible I would like to have a solution in the service environment because I have not immediately access to the Desktop version.
Thanx!
I have found the sollution!
My date field in the dataset had also milliseconds...
So when filtering on a specific date only hour:minute:second is checked so no records are found because all the records have a date field with milliseconds in it and differ from the hour:minute:second date filter.
Thanx for the respons v-yulgu-msft!
