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
    9 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!

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi vincent_janssen,

 

I didn't encounter this problem in my test. The slicer worked as expected with "Between" option or "List" option. 

 

In your scenario, could you try to re-create this report for a test? And did this problem occur to any other dataset? If possible, you could download this report to local pbix file, and test whether issue persists in Power BI desktop.

 

Best regards,
Yuliana Gu

 

 

vincent_janssen's avatar
vincent_janssen
Regular Visitor
9 years ago

Hi v-yulgu-msft,

 

Thank you for the response.

 

I can try and re-create the report. At the moment I have no other datasets. I linked PowerBI as an output to Azure Stream Analytics and the data is comming directly from ASA.

 

But I know now that it is not a bug in PowerBI so hopefully I can make it work :)

 

Kind regards

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi vincent_janssen,

     

    Does re-creating report solve this problem?

     

    Also, rather than using a multi-row card, please use a table visual to test whether it shows nothing when you select a date from the 'list' slicer.

     

    Best regards,
    Yuliana Gu

    • vincent_janssen's avatar
      vincent_janssen
      Regular Visitor
      9 years ago

      Hi v-yulgu-msft,

       

      Sorry for not responding!

       

      I re-created the report with data imported from an Excel sheet. If I have data from an Excel sheet I have no issues with the date slicer, everything works fine. 

      So I think that Azure Stream Analytics outputs a wrong type of date to the dataset in PowerBI because the date filter with the dataset form Azure Stream Analytics won't work.

       

      Thanx for the help!

       

      Kind regards,

      Vincent