Forum Discussion

Harshal's avatar
Harshal
New Member
7 years ago

How to create a custom sort order for a visualization?

Hello,   I have a requirement where i need to create plot whose axis is sorted in a way i want. E.g. my axis has stages Presentation Booked, Presentation Delivered, Hot, Warm, Contract Sent etc. I ...
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Harshal

 

You may try to use Sort by column for your column. Show a sample as below:

 

First, add custom column in Query Editor to set the sort column for your data.

 

Second, use sort by column for 'stages' column as below.

 

Last, you just need to set the sort as requested for your visual.

 

Regards,
Cherie

 

 

 

  • Harshal's avatar
    Harshal
    New Member
    7 years ago

    Hello v-cherch-msft/Cherie,

     

    Thanks a lot for your time. 

     

    I had already implemented this solution as mentioned in my question. :) But i was wondering if there was any other way to do so because i am having four graphs on one dashboard which i need to custom sort so i thought making four tables is a bit excessive!

     

    Also for one report i have my x-axis as first day of the week given as mm/dd, as it's a custom created field its stored as text thus causing troubles in getting a proper sort order. I have fixed it by appending the week number to it but the executives don't like it! If you happen to know any way to fix this also then that would be awesome!

     

    Thanks a lot!

     

    Regards,

    Harshal