Unable to select Max date on date filter

[jwilliamson1990]

Hi all,

I'm unsure on what the forum etiquette is on this but the thread I saw about this issue was closed by the person who raised it without a solution being identified.

As of roughly a month ago, when the style of the date filter seems to have changed slightly in Power BI, we've had the same issue occur across all of our reporting: where a 'between' date filter is in the report, the user is unable to select yesterday in the drop-down field (screenshot below from 25/04/2022, the report data goes up to 24/04/2022 but that day is unselectable.

Adding a slider in and dragging it all the way to the end pulls through the additional date but this is pretty terrible from a UX perspective and isn't intuitive to the report user. 

The previous thread on this posited that it could be to do with the version of Power BI we're using - screenshow below shows that we're using the April 2022 data. This same issue is occuring across 20/30 different reports.

Does anyone have any advice/idea on what's causing the issue?

[v-cgao-msft · Accepted solution]

Hi @jwilliamson1990 ,

When I tried to test with version 2.104.702.0 64-bit (April 2022), I encountered the same problem as you.
This issue was fixed when I updated my desktop to the current latest version 2.104.941.0 64-bit (April 2022).

Please use the following link to update to the latest version. Then check if the problem is solved.
Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[jwilliamson1990 · Accepted solution]

Hi @v-cgao-msft ,

Amazing, yes, thanks that seems to have solved the issue.

Thanks for the help!

[v-cgao-msft · Accepted solution]

Hi @jwilliamson1990 ,

When I tried to test with version 2.104.702.0 64-bit (April 2022), I encountered the same problem as you.
This issue was fixed when I updated my desktop to the current latest version 2.104.941.0 64-bit (April 2022).

Please use the following link to update to the latest version. Then check if the problem is solved.
Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data