Forum Discussion

Landmann's avatar
Landmann
Regular Visitor
8 years ago
Solved

How can I sort the data on my graph?

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's avatar
    v-piga-msft
    8 years ago

    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

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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