Date filter doesn't work properly

[vincent_janssen]

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!

[v-yulgu-msft]

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]

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]

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]

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

[v-yulgu-msft]

Hi @vincent_janssen,

Have you tried to format these date fields using Azure Stream Analytics Date and Time Functions?

Regards,
Yuliana Gu

[vincent_janssen]

Hi @v-yulgu-msft,

I have used the CAST() function to cast my date to datetime in Azure Stream Analytics. But unfortunately this did not work.

I can try and use another Azure Stream Analytics Date and Time Function but the only one returing a datetime is DATETIMEFROMPARTS() and this will be very complex to create and the output will be a datetime again so I think the result will be the same...

Kind Regards,

Vincent

[vincent_janssen · Accepted solution]

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]

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