Custom Sorting

[sahmed1]

Hello,

I cannot seem to sort my quarters to chronologically order.

Please help me!

Shaila 

[Vvelarde]

@sahmed1

What is the order?

Maybe this Thread can help you

https://community.powerbi.com/t5/Desktop/Sorting-Data-Manually/m-p/140138#M60320

[sahmed1]

the order is:

2017 q1 ; 2016 q4 ; 2016q3 ; 2016 q2

i need it to go

2016 q2 ; 2016 q3; 2016 q4; 2017 q1

[Vvelarde · Accepted solution]

@sahmed1

You need a extra column with the order

Quarter  Order

2016Q1  1

2016Q2  2

2016Q3  3

2016Q4  4 

...

...

After that use Sort By Column  -- (in modeling menu)