topic Custom Sort in custom Visual Urgent in Custom Visuals Development Discussion

Custom Sort in custom Visual Urgent

AakashMarasini — Fri, 20 Oct 2023 04:22:21 GMT

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

Re: Custom Sort in custom Visual Urgent

dm-p — Fri, 20 Oct 2023 04:35:56 GMT

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

Re: Custom Sort in custom Visual Urgent

AakashMarasini — Sun, 22 Oct 2023 06:27:57 GMT

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