Forum Discussion

vincent_janssen's avatar
vincent_janssen
Regular Visitor
9 years ago
Solved

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 ...
  • vincent_janssen's avatar
    vincent_janssen
    8 years ago

    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!

vincent_janssen's avatar
vincent_janssen
Regular Visitor
8 years ago

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!

khush19's avatar
khush19
Icon for Resolver I rankResolver I
6 years ago

what is the solution for this ,As for me also Filters are not working on data coming from Stream Analytics to PowerBI

I a trying to put filter on column date1 and now but no output,Even now doesn't show time value

As you can see first 3 fields are coming from SA to PowerBI ,but rest no output as Filter is not working