Column Secondary Sort Order

Question

I have a bunch of orders, each with a status of Won, Lost or Open. All of these orders are divided by region. So I throw them all up on a Clustered Column chart, sorting by region. Great - all works. Except that for each region, the order of the columns within the region is alpha - Lost, Open, Won. I need it to be Won, Open, Lost.&nbsp;So I created a new column - Status Order - and populated it with:&nbsp;Status Order = IF('Order'[Status] = "Won",
                  1,
                  IF('Order'[Status] = "Open",
                     2,
                     3))

and used the Sort by Column item in the Modelling tab to sort by that column rather than by the Status column, which it was sorting by.&nbsp;It didn't work - made no difference at all to the display.&nbsp;What am I doing wrong? Or not doing?&nbsp;Thanks in advance.

jthomson · Answer

Rather than make a new column you could just create a new table saying Won 1, Open 2, Lost 3 and then link it, then try to sort by that column?

budfudder · Answer

I'm not sure how/whether that would work - my data source is actually one very long SQL statement pulling in five or six tables from the database.

anonymous · Answer

"and used the Sort by Column item in the Modelling tab to sort by that column rather than by the Status column, which it was sorting by.&nbsp;It didn't work - made no difference at all to the display."&nbsp;- Could you please post the snapshot of how you do this sorting?&nbsp;ThanksRaj

budfudder · Answer

See below&nbsp;

nipponsahore · Answer

try this,&nbsp;&nbsp;Drag drop the "Status Order" Column into the tooltip section of the chart and sort the chart on this "Status Order"

Forum Discussion

Column Secondary Sort Order

7 Replies

Related content

Sequential Order column based on multiple criteria

Remove Secondary columns in Matrix Visual

Matrix Column Order reseting

Matrix Column Head Order

secondary axis