Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Top N Filter doesn't work


I have an issue with the Top N filter option on a visual. It simply doesn't interact with the table as intended.

Current status:


I need to see only the first row with MAX Value= 6. 

What are the typical reasons why this filter can't work properly? And if not possible to use it, what kind of measure can I write to replace it?



Helper II
Helper II

@meenakp I am still stuck with this issue.

Here is my latest version:


The filter is activated, the measure tie reports two distinct numbers. It should work but doesn't. Any idea why?

Resolver I
Resolver I

@Berl21, This could be a simple fix. After you select "TOP 1" there will be a "Apply filter". You have to click on it.

In your case it will be just below "MAX Value" highlight you are showing here.

@meenakp Unfortunately it is already activated 😞 I don't get what could be in the way of this filter...

I also tried to replace this filter with a simple measure that should report only the top cases when using a classic filter:

Measure =

IF([Max]=[Rank Stage MEASURE],1,0)

I set the filter in this way:


The problem with this is that it is not dynamic. "1" gets populated to the last entry, regardless of the time frame set in the slicer. 

I need to replace this measure with a dynamic version of it, or fix the top n filter. 

Do you have any ideas about this?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors