Sorty by Date and then ID

[azaterol]

Hello everyone,

I have given the following situation:
This is sorted by date in descending order. As you can see, the ID on the left is not in chronological order.

ID		Date		Customer Number
10		29.06.2022 00:00		12778
9		29.06.2022 11:17		80015
11		30.06.2022 00:00		11386
12		30.06.2022 00:00		11168
13		30.06.2022 00:00		11219
18		01.07.2022 00:00		12146
17		01.07.2022 00:00		11334
16		01.07.2022 00:00		11369
19		01.07.2022 00:00		12166
20		01.07.2022 00:00		12897
15		01.07.2022 00:00		11671
14		01.07.2022 00:00		11777

The date should still be in chronological order. When this is done, the ID should then expire chronologically.

This would be the result I then expect in Power BI...

ID		Date		Customer Number
10		29.06.2022 00:00		12778
9		29.06.2022 11:17		80015
11		30.06.2022 00:00		11386
12		30.06.2022 00:00		11168
13		30.06.2022 00:00		11219
14		01.07.2022 00:00		11777
15		01.07.2022 00:00		11671
16		01.07.2022 00:00		11369
17		01.07.2022 00:00		11334
18		01.07.2022 00:00		12146
19		01.07.2022 00:00		12166
20		01.07.2022 00:00		12897

Does somebody has any idea?

I tried it with an index column, but I can sort either by date or by ID, unfortunately that didn't help me.

[jaideepnema · Accepted solution]

Hi @azaterol ,

You can use Shift + Left Click on the column header to sort this accordingly. 

https://www.c-sharpcorner.com/article/how-to-sort-a-table-using-multiple-columns-in-power-bi/#:~:tex....

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

[azaterol]

@jaideepnema  Thank you.