Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
AakashMarasini
Frequent Visitor

Custom Sort in custom Visual Urgent

Hello Developers!

I am having many categorical data so I have to use the custom sort in my custom visual.

I have followed the documentation : https://learn.microsoft.com/en-us/power-bi/developer/visuals/sort-options

But the sorting options (menu) is not generated in the power bi so that i can change the order of each data fields as per my wish.

I have implemented as follows:
Visual.ts: 

 

 

 

 

 

import CustomVisualApplyCustomSortArgs = powerbi.extensibility.visual.CustomVisualApplyCustomSortArgs;

//In VisualUpdateOptions:

let queryName1 = datas.categorical.categories[0].source.queryName;
  console.log('queryname1',queryName1)
//output: Table.columnName
  let queryName2 = datas.categorical.categories[1].source.queryName;
  let args: CustomVisualApplyCustomSortArgs = {
      sortDescriptors: [
          {
              queryName: queryName1,
              sortDirection: powerbi.SortDirection.Ascending
          },
          {
              queryName: queryName2,
              sortDirection: powerbi.SortDirection.Ascending
          },
      ]
  };

this.host.applyCustomSort(args);

 

 

 

 
capabilities.json:
 

 

 

"sorting": {

  "custom": {}

}

 

 

I have also looked into the other custom visual open source. All of them are using implicit and default method.

Thank You!

@v-viig @dm-p 

2 REPLIES 2
dm-p
Super User
Super User

Hi @AakashMarasini,

 

I don't have any experience with the custom sorting API, but my understanding is that it will not add anything to the visual header, which is what default sorting is for. This custom API is intended for more complex scenarios than the visual header UX can manage, and I believe that it's something that the developer has to manage the display of (and add elements to manage the sorting operations for and drive this API) in their visual DOM.

 

Regards,

 

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Hi @dm-p 
Thank you for your response. I thought I should use the custom API to have sort options for multiple data fields. If I cannot add a sort option to the visual header using the custom API, how could i achieve this feature?
With the default sort, sort options are not available for all my data roles. It is available for only two data fields: one categorical and one measure respectively in my case. 

I have used as:

"sorting": {

  "default": {
   
  }

}


Regards,
Aakash

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors