Forum Discussion
Changing time in filter changes also the date
HI q01_1gt,
I test with the latest 64-bit power bi desktop but can't reproduce your issue. What version of power bi desktop are you test? Can you please share a sample pbix file to test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi,
sorry I didn't specify that the issue happens olny when using the report deployed on the web.
In any case the report has been developed with PowerBI Desktop Version 2.76.5678.782 64-bit, but as previously said the issue is not present in the Desktop app.
The filter corresponds to a field associated to Date type with format dd/mm/yyyy.
From the web player when we change the time it also change the date.
Furthermore today I noticed that sometimes the filter behavior seems to consider the date format as mm/dd/yyyy.
For example if I open the calendar selection I can see dates of the current month:
If I select for example 1st of May (01/05/2020 in dd/mm/yyyy) is then shown as 05/01/2020:
And if I open again the calendar it shows dates of January, as if I previously selected 5th of January instead of 1st of May:
My pbix connects to external datasource so I believe I am not able to share it with you.
Best regards
Hi q01_1gt,
It sounds like a transform/recognize issue between different device system locale and power bi desktop locale date formats. Did this issue still appear if you change your locale setting to keep them in the same format?
If it fixed after you change the locale settings, I'd like to suggest you contact to power bi team with a dummy pbix file to help them reproduce this and fix this issue in the next version of power bi desktop.
Regards,
Xiaoxin Sheng