Creating a custom order

[Michael11]

Hi All

I am just in need of help with ordering the x axis of my graph. I would like the titles to be in a specific order - i have tried a few methods from watching videos however cannot get it to work. It is a large file i am working with that has many columns.

Essentially, this is a bunch of different job names scattered throughout the report, but must be in a specific order. Can someone assist the process with this?

The list of jobs are appearing like this:

- sales

- stock

- clean

- close 

- open

And i need to get  it so the visuals shows them in this order on the x axis:

- open

- stock

- sales

- clean

- close

[tamerj1 · Accepted solution]

Hi @Michael11 
Start by adding index column using power query

Then creating a soring column in using DAX

Sort = 
SWITCH (
    Jobs[Index],
    5, 1,
    2, 2,
    1, 3,
    3, 4,
    4, 5
)

Sort [Job] by [Sort]

And this is how the chart look like