Date acting like text in Excel

Question

I have a field (termination date) that is set to date in power query. It is set to date in desktop.

When the user's use Power BI as a data source in excel, it's behaving like text. I'm at a loss.

anonymous · Answer

Hi&nbsp;Mamaof2QTz&nbsp;,
&nbsp;
Here I create a sample to have a test. [Row Labels] is date type in Power Query Editor.

Then I get pivot table in Excel. It is date type as well and the sort works well.

In your screenshot, the column looks like text type. I think the data type in semantic model may be text type though the data type in power query editor is date. And I can reproduce your issue, the column in excel will be sorted like text.

You can change the data type in column tool to date and republish your report. Then it will work.
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;