Date sorting - Data Model (PowerPivot)

[zico8]

Hi,



I have 1 column with dates.

When creating PivotTable in the standard way, the sorting is correct, whilst doing this by adding my data to data model the sorting is incorrect. Why?

[mehdi_154]

Hi, was it necessary to have the "#value error" in the worksheet called date? Just removed it and sorted the date from A- Z. Should be working now

[zico8]

I realized this also,

But the problem is that for some records I have no date, but cannot remove its from my data set.
Is there any way to keep these (maybe by replacing errors into any value) and then filter directly in pivot table?

[XOR LX]

Hi,

Remove the errors in Power Query first.

Regards

[zico8]

Thanks a lot,

It works now!