214
P

Analyze in Excel Date Columns - Convert Text -> Date

Power BI User on 5/5/2020 7:40:38 PM
214
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!
STATUS DETAILS
Planned
2022 Release Wave 2

Administrator on 6/14/2022 5:54:28 PM

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

Comments

P

P

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

Gui Vendemiatti on 2/18/2021 3:26:25 PM

This needs to be addressed!!!

P

P

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

Cedric CHABERT on 2/2/2021 11:53:09 AM

How can this not be posible? what's the point of ANY analysis if you can not have a clear date filter? Come on this can not be in a "need votes" status it is just a BASIC functionnality

P

P

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

Adam Canale on 1/26/2021 8:24:11 PM

PLEASE ADDRESS THIS!!!

P

P

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

Ross Nelson on 12/31/2020 9:45:10 PM

Still not fixed? I can't imagine this would be a huge undertaking for devs to resolve.

P

P

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

Guido Lenzi on 9/30/2020 11:32:57 PM

My god .... this is really said... it is hard to see some Microsoft areas working on big things, bringing so good products but in the other hand other with really basic problems that cause this much impact on a software. until today no one looked at this... this is common problem of a bureaucratic process of listening to client demands through a single channel and plastered process classifying tall in the same bucket

P

P

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

Rick Trask on 9/28/2020 8:58:58 PM

After all these years this is still out here, WOW. Why is it so hard to understand that without the ability to group the date in the Pivot Table, the connector is essentially worthless for most use cases? I will keep on using the Excel data connector options directly to the data source to get proper data formats.