Power BI

Planned

Analyze in Excel Date Columns - Convert Text -> Date

Vote (286)

Power BI User on 05 May 2020 19:40:38

When connecting to Power BI datasets using Analyze in Excel, all date fields from models show up in pivot tables as text, which disables filtering or grouping for date groups.

It is possible to fix this or give us a workaround to set columns as date?

Thanks!

Administrator on 14 Jun 2022 17:54:28

This is an Excel feature that is being actively worked on by the Excel team. Updates to follow.

Comments (40)

Comments (40)

German Petrov-Nerling on 25 Sep 2024 00:42:50

RE: Analyze in Excel Date Columns - Convert Text -> Date

Also need this feature to be added. It is been pending for 4+ years. Shame for Microsoft!

Remi Øvstebø on 09 Apr 2024 12:56:51

RE: Analyze in Excel Date Columns - Convert Text -> Date

Cmon.. several years and still waiting.

Juan Jourde on 19 Jan 2024 18:40:34

RE: Analyze in Excel Date Columns - Convert Text -> Date

To be honest, this feels a lot more like a bug than a feature. Looking forward to the fix.

Meg M on 26 Sep 2023 19:05:18

RE: Analyze in Excel Date Columns - Convert Text -> Date

Any update on delivery time-frame for this fix? Seems like low hanging fruit that will save users a lot of frustration.

on 22 Sep 2023 08:58:36

RE: Analyze in Excel Date Columns - Convert Text -> Date

Still waiting for this...

Quinten Beune on 22 Aug 2023 11:52:17

RE: Analyze in Excel Date Columns - Convert Text -> Date

Dear MS fabric/bi developers, could you please provide a delivery timeline on this feature?

Stephen Lightfoot on 26 May 2023 13:25:26

RE: Analyze in Excel Date Columns - Convert Text -> Date

This is affecting me also. Using Office 365 version of Excel. Really frustrating that this has been outstanding for almost 3 years! Do you have an update as to when this is planned to be fixed?

Shoaib Ahmed on 21 May 2023 21:05:33

RE: Analyze in Excel Date Columns - Convert Text -> Date

This is pending since 3 years. Seriously !!!

Craig Dormire on 16 May 2023 18:10:25

RE: Analyze in Excel Date Columns - Convert Text -> Date

Any updates or ETA for Excel fix? Thanks!

Stephanie Kjeldsen on 01 May 2023 09:27:21

RE: Analyze in Excel Date Columns - Convert Text -> Date

Come on Microsoft, we have been waiting for this for years! Please give us an update on this feature. It is totally crazy that we need to create all sorts of workarounds, per date! We have critical reports with the entire supply chain date milestones, which is so powerful, but we can't enable this simple feature so users can be more self sufficient digging into the data!