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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

TopN Filter always orders by first column

 
        let tableName = 'table';
        let column = 'column3'

let filterTarget: models.IFilterColumnTarget = { table: tableName, column: column }; let orderByTarget: any = { table: tableName, column: column } let advancedFilter = new models.TopNFilter( filterTarget, this.direction, 10, orderByTarget
);
this.visualHost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);

 

So I have this filter that I created like above and I'm applying this filter to my dataset for a custom visual. I am also ordering the filter by the column that I am filtering (my table has 5 columns), so that the filtered column is sorted.

 

However, for some reason, it is always ordering by column 1 and not ordering the column that I want it to order (column 3).  This means that my column 3 will never get ordered. Can anyone help regarding this? Thanks!

 
1 REPLY 1
v-evelk
Employee
Employee

Hello,

 

I've requested clarification from an appropriate specialist.

As soon as I get a response, I will provide it here.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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