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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How can I SortOrder in...
Power Apps
Answered

How can I SortOrder in a quickchart chart ?

(0) ShareShare
ReportReport
Posted on by 411

Hello Community:

 

I have this chart inside powerapps by using QuickChart 

 

This next code is working fine: 

"https://quickchart.io/chart?c="&EncodeUrl("{
 type: 'bar',
 data: {
 labels: ["&Concat(colDefectCounts,"'" & DescripciónDefecto & "'" & ",") & "],
 datasets: [
 {
 label: 'Top 5 Defects',
 data: [ "&Concat(colDefectCounts,"'" & DefectCount & "'" & ",") & "],

 backgroundColor: ['rgba(255, 99, 132, 1)', 'rgba(54, 162, 235, 1)', 'rgba(255, 206, 86, 1)', 'rgba(75, 192, 192,1)', 'rgba(217, 48, 214,1)'],
 borderColor: ['rgba(255, 99, 132, 1)', 'rgba(54, 162, 235, 1)', 'rgba(255, 206, 86, 1)', 'rgba(75, 192, 192, 1)','rgba(217, 48, 214,1)'],
 borderWidth: 1,
 },
 ],
 },
 options: {
 plugins: {
 datalabels: {
 anchor: 'center',
 align: 'center',
 color: '#fff',
 font: {
 weight: 'bold',
 },
 },
 }, legend: {
 display: false,
 }
 },
}
")

 

HectorOlivos_1-1690908969783.png

 

 

How can I Sort Order Ascending this part: 

 data: [ "&Concat(colDefectCounts,"'" & DefectCount & "'" & ",") & "],

 

i tried with this but is not showing anything: 

 

 data: [ "& Concat( SortByColumns(colDefectCounts,"DefectCount"), "'"& SortOrder.Ascending & "'" & ",") &" ],

 

HectorOlivos_0-1690908830558.png

 

Thanks

 

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @HectorOlivos ,

     

    Please try:

     

    Concat(Aort(colDefectCounts,DefectCount,SortOrder.Ascending),"'" & DefectCount & "'" & ",")

     

     

    Best Regards,

    Bof

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard