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

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

8 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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
        Microsoft Employee
        8 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