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...
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

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