Top N Slicer

Dynamic Top N Filtering

Build

Build

top-n-rank

Overview

Features

Prompts

Help

Key Features

Your bar chart shows every product, country, or customer — but you only care about the top performers. Power BI's built-in Top N filter breaks with external slicers and doesn't update dynamically. The correct approach uses a ranking measure with the right filter scope to respect all slicer context, but implementing it requires a disconnected table, a rank-based filter measure, a visual-level filter, a dynamic title measure, a numeric slicer, and interaction restrictions so the slicer only affects the target chart. This skill builds all of it in one command — run it with /top-n-rank.

How it works

Type /top-n-rank, provide the visual ID, and the skill builds everything:

  1. Creates a disconnected numeric parameter table (reuses existing one if present)

  2. Creates a show/hide measure using a rank function with the correct filter scope — returns 1 for top N items, 0 otherwise

  3. Creates a dynamic title measure that updates automatically when N changes

  4. Applies a hidden visual-level filter on the target chart

  5. Sets the dynamic title on the chart

  6. Adds a "Top" text label and numeric slider slicer above the chart

  7. Restricts slicer interactions so the Top N slicer only filters the target chart

What you get

  • Disconnected numeric parameter table — with configurable range and default N

  • 2 DAX measures — a rank-based show/hide filter and a dynamic title

  • Visual-level filter — hidden filter applied to the target chart

  • Dynamic title — updates automatically when N changes (e.g., "Top 10 Countries by Sales")

  • Numeric slider slicer — compact slider with default selection, no header, transparent background

  • "Top" text label — positioned above the chart, aligned with the slicer

  • Scoped interactions — slicer only affects the target chart, not other visuals on the page

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD

Category

Build

Version

Version 2.1.1.2.15

or log in if you already have an account