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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors