Changing time in filter changes also the date

Question

Hi,we are currently facing an issue in our reports. When we try to change minutes in our time filter, it automatically changes also the date of the filter.Reports were not changed in the last weeks and this problem has begun to happen only during the last days.Here you can find a video of the issue:&nbsp;https://drive.google.com/file/d/1W8l7kowe_8ctHIf5CJlpx5uhF2_xVSuT/view?usp=sharing&nbsp;Do you have any hint on this?&nbsp;Best regards

sanimesa · Answer

q01_1gtCan you please post a screenshot? The video is not loading, perhaps a bit too large.

q01_1gt · Answer

Of course, thanks.&nbsp;This is the filter default:&nbsp;When we increase the minute, also the date changes simultaneously:&nbsp;Every time we increase/decrease minutes the date shown in the filter changes from 01/02/2019 to 02/01/2019.&nbsp;Thanks for your support.

anonymous · Answer

HI&nbsp;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?&nbsp; Can you please share a sample pbix file to test?
How to Get Your Question Answered Quickly &nbsp;
Regards,
Xiaoxin Sheng

q01_1gt · Answer

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&nbsp;2.76.5678.782 64-bit, but as previously said the issue is not present in the Desktop app.&nbsp;The filter corresponds to a field associated to&nbsp;Date&nbsp;type with format&nbsp;dd/mm/yyyy.&nbsp;&nbsp;From the web player when we change the time it also change the date.&nbsp;Furthermore today I noticed that sometimes the filter behavior seems to consider the date format as&nbsp;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&nbsp;dd/mm/yyyy) is then shown as&nbsp;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:&nbsp;My pbix connects to external datasource so I believe I am not able to share it with you.&nbsp;Best regards

anonymous · Answer

Hi&nbsp;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

Forum Discussion

Changing time in filter changes also the date

5 Replies

Related content

Monthly Automatic Change

Changing Your Community Language Preferences

Change Default Lakehouse

Black slicer apper when change Visual

change fabric capacity