Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

 

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 !

 

Capture.PNG

 

Thanks 

Jimmy

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. 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

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

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors