Power BI Desktop February 2020 Data view - Filters on calculated date columns not working

[Anonymous]

Hi,

The date filters on a calculated "date" column not working in POwer BI desktop Feb 2020 - Version: 2.78.5740.861 64-bit (February 2020). 

Anyone got a workaround ?

Jimmy

[Greg_Deckler]

Not 100% sure what you mean by that. Can you provide an example PBIX? Upgrade to March 2020?

[Anonymous]

Hi,

Unable to upgrade to March 2020, not yet approved in the corporate media library. 

Screenshot attached as below, When I choose any date filters on a calculated date column ( it works on native date columns) it does not show the next option to enter the values !

Thanks 

Jimmy

[Greg_Deckler]

I can confirm that this works in the March version. Rollback to the November 2019 version? I don't see this getting fixed or anything that Microsoft can do about this as if it is indeed an issue, it has already been resolved.

One thing to check is I have seen behavior where a window like the interface that you say is not getting displayed gets opened up underneath other windows or on a different monitor, etc. 

[Anonymous · Accepted solution]

Thanks all,

I will use my good old Excel ( thanks to copy table in Power BI) to do data discovery. I hope Microsoft will be bit more diligent before introducing bugs  - spare a thought for people who can't just upgrade or rollback the toolsets !!

Stay safe

Jimmy

[amitchandak]

This is dd/mm/yyyy format. Has it been correctly detected as the date. Check datatype and format