Forum Discussion

Michael11's avatar
Michael11
Frequent Visitor
4 years ago
Solved

Creating a custom order

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

Need Help
Show and Tell
Tutorial Requests
  • tamerj1's avatar
    tamerj1
    4 years ago

    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

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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