web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Custom Sorting in Charts

(1) ShareShare
ReportReport
Posted on by 34

Hi,

Is there any way to rearrange the values in a bar chart so that they are not in alphabetical order? I want the values to be in a specific series, like /Very difficult/ to /Very easy/.


 
 

 

 

 

 

I have the same question (0)
  • Suggested answer
    Dengliang Li Profile Picture
    Microsoft Employee on at
    Custom Sorting in Charts
    Hi,
     
    I'm afraid that's not possible.
    You can arrange the values in the bars according to the labels of the option set fields.
    However, it is based on the alphabetical order of the label text.
     
    In my testing, I created an option set field.
    Added these two lines of code to the XML of the chart to sort the bar values in positive order based on the label text of the option set.

    In the chart, records with the option set field labeled Empty (None) are in the first group, after which they are sorted into groups based on the alphabetical order of the label.
    Therefore, if all of your options begin with the letter V, the records will all be in the same group.
    Whereas before it was sorted by the value of the option set, now it is sorted alphabetically by the text label of the option set.
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me .
     
    Best Regards,
    Dengliang Li
     
     
  • TA-23051225-0 Profile Picture
    34 on at
    Custom Sorting in Charts
    Thanks for the answer Dengliang Li.
     
    This chart is created from Customer Survey Question Responses(Customer Voice). 
     
    Is there any way I can use the option set value sorting in this. I am not able to find any Optionset field related to this in D365 entities. I want to arrange the chart according to this but it is set alphabetically by default.
     


    Thanks

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 284

#2
Sohaib Cheema Profile Picture

Sohaib Cheema 104 User Group Leader

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 77

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans