Date column in Excelpivot incorrect format

[Nick001]

Hi, everyone,
I have created an access from Excel to my Power BI data set (get data fram Dataset). 
The data also arrive in Excel and I can use the data model in a pivot. But now to my little challenge, the date fields do not arrive as a date, but as text in the pivot. This makes it very difficult to filter these columns.
In power BI they are created as date fields and work accordingly

Is there a way to define the fields as dates in Excel for the Pivot?

best regards
nick

[Anonymous · Accepted solution]

Hi  @Nick001 ,

Here are the steps you can follow：

1. Enter the Power query interface and select the date column.

2. Select the two columns, Right Click --Change Type - Using Locale.

3. Select in Data Type: Date and Set the Locale (in your case you can use English - United States).

If the result is not what you expected, can you share sample data and sample output in table format?

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Nick001]

THX, that works great - sorry for the late answer