Paginate Visual
DAX-Driven Pagination
Build
Overview
Features
Prompts
Troubleshooting
Key Features
Your bar chart shows 50 items but only 10 fit on screen. Power BI has no built-in pagination — you either accept a scroll bar, use Top N and lose the rest, or build a RANKX/page-filter pattern from scratch. This skill creates the disconnected pages table, rank and filter measures, visual-level filter, and page-number slicer in one command.
How it works
Type /paginate-visual, provide the visual ID, dimension, and ranking measure, and the skill builds everything:
Creates a disconnected
# Pagestable (reuses existing one if present)Creates 3 DAX measures — item rank, item filter, page filter
Applies a visual-level filter on the target visual
Adds a horizontal page-number slicer with page 1 as default
Handles multi-column visuals, exclusions, and custom page sizes
What you get
Disconnected pages table —
# Pageswith values 1 through max pages3 DAX measures —
{Prefix} Item Rank,{Prefix} Item Filter,{Prefix} Page FilterVisual-level filter — applied to the target visual so only the current page of items shows
Page slicer — horizontal button slicer for page navigation
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.
Clone Page
Build
Clone any report page with all visuals, bookmark navigators, interactions, and drillthrough bindings as a fully independent copy.
Convert to Trendline
Build
Add formatted data labels, markers, area shading, and a canvas tooltip to line chart visuals.