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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BobWong1
Helper I
Helper I

Top N function does not work in the Filter Pane?

I tried to use the Top N filter function in Filter Pane as shown;

When I tried to drag a field/measure into the <<By Value>> well of 'Add data fields here', in my case I can't, why?

Is it Power BI Desktop having a problem in this area or is there a limitation of type of fields/measure that I could use?

BobWong1_0-1707296969967.png

 

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

@BobWong1 

you can use measure with TOPN, as shown below.

Daniel29195_0-1707330435582.png

can you share the measure you are trying to use with the TOPN ? 

 

best regards

View solution in original post

2 REPLIES 2
Daniel29195
Super User
Super User

@BobWong1 

you can use measure with TOPN, as shown below.

Daniel29195_0-1707330435582.png

can you share the measure you are trying to use with the TOPN ? 

 

best regards

Dear Daniel,

I managed resolved this issue after I restart Power BI Desktop. It seems to me at certain condition, it may not work. Nevertheless, I should close this issue aa accepted solution. Thanks anyway for your kind reply.

BR,

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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