Changing time in filter changes also the date

[q01_1gt]

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: https://drive.google.com/file/d/1W8l7kowe_8ctHIf5CJlpx5uhF2_xVSuT/view?usp=sharing

Do you have any hint on this?

Best regards

[sanimesa]

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

[q01_1gt]

Of course, thanks.

This is the filter default:

When we increase the minute, also the date changes simultaneously:

Every time we increase/decrease minutes the date shown in the filter changes from 01/02/2019 to 02/01/2019.

Thanks for your support.

[Anonymous]

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

[q01_1gt]

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

[Anonymous]

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