Top N Slicer
Dynamic Top N Filtering
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:
Creates a disconnected numeric parameter table (reuses existing one if present)
Creates a show/hide measure using a rank function with the correct filter scope — returns 1 for top N items, 0 otherwise
Creates a dynamic title measure that updates automatically when N changes
Applies a hidden visual-level filter on the target chart
Sets the dynamic title on the chart
Adds a "Top" text label and numeric slider slicer above the chart
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
Explore more in this category

Absolute / Percentage Toggle
Build
Add a two-button tile slicer to any chart that switches between absolute values and a percentage variant, with a dynamic format string and auto-derived chart title.

Active Filters Card Visual
Build
Generate a card visual that dynamically displays all currently active slicer and filter selections.

Apply rounded
Build
Convert standard column or bar charts to a lollipop "rounded column" style using Power BI's native error bar feature

Clone Page
Build
Clone any report page with all visuals and bookmarks
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

