How can I sort the data on my graph?

[Landmann]

Hello everybody!

I am currently trying to sort the data on my graph (on the x-axis) in a certain way but it doesn't seem to work.

Currently my graphs show data like this (x-axis):

01, 02, 03, ..., 12, CF02, CY17, Target

But I want them do be displayed in this order:

CY17, 01, 02, ..., 12, Target, CF02

So I created a new table, assigned a number to each value and created a relationship to my basedata. Then I used "related" function in my basedata to assign the numbers to the respective entry.

However, this is what BI does:

Can somebody tell me why it doesn't work? I looked this approach up on the internet and it should work like this...

Thank you for your help!

[v-piga-msft · Accepted solution]

Hi @Landmann,

May be you could try this way without creating a new table. By the steps below you could get your expected order.

1. Go to Query Editor, add a conditional column.

2. Apply && Close. Go to Data View and select column1 sort by custom column, then you could create the visual.

Hope this can help you!

Best Regards,

Cherry