Date sorting from oldest to newest in Matrix

[learner03]

I have a matrix table and I need to sort by oldest Delivery Date.

The format type of Delivery column is Date. If I drag this column in Matrix rows, it only gives me earliest or latest date, and it shows the earlist date or latest date in every line. And if I chage this delivery column as Text type field, then it doesn't sort from ascending to descending date properly.

How can I properly sort?

SO #	Create Date	Delivery Date
SO00309863	24/01/2022 0:00	7/02/2022
SO00309864	24/01/2022 0:00	11/02/2022
SO00310013	27/01/2022 0:00	10/02/2022
SO00310015	27/01/2022 0:00	11/02/2022
SO00310016	27/01/2022 0:00	16/02/2022
SO00310017	27/01/2022 0:00	10/02/2022
SO00310018	27/01/2022 0:00	10/02/2022
SO00310019	27/01/2022 0:00	8/02/2022
SO00310020	27/01/2022 0:00	10/02/2022
SO00310021	27/01/2022 0:00	10/02/2022
SO00310022	27/01/2022 0:00	8/02/2022
SO00310023	27/01/2022 0:00	10/02/2022
SO00310024	27/01/2022 0:00	10/02/2022
SO00310025	27/01/2022 0:00	8/02/2022
SO00310026	27/01/2022 0:00	10/02/2022
SO00310027	27/01/2022 0:00	9/02/2022
SO00310045	27/01/2022 0:00	16/02/2022
SO00310046	27/01/2022 0:00	15/02/2022
SO00310135	1/02/2022 0:00	21/02/2022
SO00310136	1/02/2022 0:00	15/02/2022
SO00310282	3/02/2022 0:00	21/02/2022
SO00310283	3/02/2022 0:00	23/02/2022
SO00310284	3/02/2022 0:00	18/02/2022
SO00310285	3/02/2022 0:00	18/02/2022
SO00310287	3/02/2022 0:00	21/02/2022
SO00310289	3/02/2022 0:00	23/02/2022
SO00310295	3/02/2022 0:00	10/02/2022
SO00310297	3/02/2022 0:00	10/02/2022
SO00310302	3/02/2022 0:00	10/02/2022
SO00310303	3/02/2022 0:00	10/02/2022
SO00310309	3/02/2022 0:00	10/02/2022

[amitchandak]

@learner03 , if drag delivery to rows of Matrix, it should not ask for first or last. It should to only when you drag it values.

Also, a text date column can have a date sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[learner03]

@amitchandak  yes sorry, i am putting that in values. How can i do that in ascending order?

[Anonymous · Accepted solution]

Hi @learner03 ,

It is by design. The values put into the matrix need to be aggregated values. Thus each row in the matrix corresponds to only one value.

Best Regards,

Jay