Forum Discussion

bselby's avatar
bselby
Frequent Visitor
7 years ago
Solved

Custom Sort on Line Charts

Good afternoon,   I have a question about creating a custom sort on a line chart, which I thought would be fairly simple but is actually proving very difficult.   The scenario I'm having issues w...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi bselby,

     

    Did you have a date dimention table in this scenario? If not, please create one via CALENDAR function. Establish a relationship between date dimention table and source data table. Rather than add [Month] from source data table, please drag it from date dimention table onto X-axis instead. Also, the custom sort should be applied to date dimention table.

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi bselby,

 

Did you have a date dimention table in this scenario? If not, please create one via CALENDAR function. Establish a relationship between date dimention table and source data table. Rather than add [Month] from source data table, please drag it from date dimention table onto X-axis instead. Also, the custom sort should be applied to date dimention table.

 

Regards,

Yuliana Gu

  • bselby's avatar
    bselby
    Frequent Visitor
    7 years ago

    Hi Yuliana,

     

    Thank you for your response.

     

    In the above example I didn't have a seperate Date table, as I couldn't create a new table in Direct Query mode for a SAP HANA Database. However I have been advised in a separate thread that if I swap it to a "relational source" from the options, it will enable that sort of functionality.

     

    Having done that first, I have followed your suggestion and created a Date table via the CALENDAR function, added my custom sort to that table and used them both on the visual. I am happy to say that it now works perfectly:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Thank you very much for your help!