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
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
Microsoft Employee
Microsoft 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
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.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors
Top Kudoed Authors