Top N Slicer

Back

Dynamic Top N Filtering

Build

Overview

Features

Prompts

Help

Key Features

Your chart lists every product, country, or customer, but the story is in the top handful — or sometimes the worst few. Power BI's built-in Top N filter is awkward: it doesn't always honour your other slicers, and it won't let readers change N themselves. Doing it properly means a ranking measure with exactly the right filter scope so the order recomputes as people slice by date or region, plus a disconnected table to drive a slider, a filter to drop the non-top categories off the chart, a title that names the current N, and interaction rules so the slider only touches its own chart. This skill builds the lot from one command — Top or Bottom, your choice — using SQLBI's RANK approach so totals and ties behave and your other slicers are always respected — run it with /top-n-rank.

How it works

Type /top-n-rank, point it at your chart(s), and it asks a couple of quick questions before building everything:

Reads your chart — finds the dimension to rank, the measure to rank it by, the measure table, and whether the chart sits in a bookmark group
Asks a few things — Top N or Bottom N, the default N (5, 10, 15, 20, or your own), whether to add a subtitle, and — for several charts — whether they share one slider or each get their own
Builds the slider table — a small disconnected table that drives the numeric slider
Writes the ranking — a Show/Hide measure (RANK + ALLSELECTED) that returns the top/bottom N and recomputes under any slicer, applied as a visual-level filter so the other categories drop off the axis
Adds a self-updating title — names the current N and dimension, e.g. "Top 10 Countries by Sales" (plus an optional "Showing top 10 of 240" subtitle)
Drops in the slider — a compact numeric slider with a "Top" / "Bottom" label, right-aligned above the chart and sized to your theme
Keeps interactions clean — the slider drives only its own chart, and nothing else on the page can move it
Follows bookmarks — if the chart shows and hides with a bookmark, the slider and label are grouped with it, and the top-N restriction is re-asserted after navigation

What you get

A top/bottom slider — a compact numeric slider with a "Top" or "Bottom" label, right-aligned above the chart and sized to your theme
Live ranking — a Show/Hide measure (RANK + ALLSELECTED) that recomputes as people slice, dropping every category outside the top/bottom N off the chart
A self-updating title — names the current N and dimension, e.g. "Top 10 Countries by Sales"
An optional subtitle — "Showing top 10 of 240 Countries", if you want it
A slider table — a small disconnected table behind the slider; its own per chart, or one shared across several
Clean interactions — the slider drives only its own chart; everything else on the page is left alone
Bookmark grouping — set up for you when the chart is shown and hidden by a bookmark