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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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!


My course: Introduction to Developing Power BI Visuals


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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors