Forum Discussion
Date filter doesn't work properly
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!
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
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
Hi vincent_janssen,
Have you tried to format these date fields using Azure Stream Analytics Date and Time Functions?
Regards,
Yuliana GuHi 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
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!