power-bi-filters
Power BI Filters lets you add, remove, and manage filters at the page and visual level on PBIR reports without needing Power BI Desktop. Use categorical filters to include or exclude values, TopN filters to show top or bottom ranked items, and relative date filters for rolling time windows. Batch multiple filter changes with --no-sync for efficiency.
Power BI Filters adds, removes, and manages page-level and visual-level filters on PBIR reports using pbi-cli.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-22
Power BI Filters adds, removes, and manages page-level and visual-level filters on PBIR reports using pbi-cli. Power BI Filters lets you add, remove, and manage filters at the page and visual level on PBIR reports without needing Power BI Desktop. Use categorical filters to include or exclude values, TopN filters to show top or bottom ranked items, and relative date filters for rolling time windows. Batch multiple filter changes with --no-sync for efficiency.
Use it when
- Power BI Filters supports TopN filtering to display the top or bottom N items ranked by a measure.
- Power BI Filters enables relative date filtering for rolling time windows without manual date entry.
Verify before relying
Read SKILL.md below before installing (1 file). Open directory: indexed for reading, not audited.
Install
julianobarbosa/claude-code-skills/power-bi-filters · repository language: Python
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do you add filters to Power BI reports using power-bi-filters?
Power BI Filters lets you add page-level or visual-level filters directly on PBIR reports. You can apply categorical filters to include or exclude specific values, use TopN filters to rank items by a measure, or set relative date filters for rolling time windows. Configure filters without needing Power BI Desktop by specifying the filter type, target column, and conditions.
What is a top 10 filter in Power BI and how does power-bi-filters handle it?
Power BI Filters supports TopN filtering to display the top or bottom N items ranked by a measure. For example, you can show the top 10 sales regions or bottom 5 underperforming products. The skill ranks items according to your chosen measure and restricts the visual to only those ranked entries, making it easy to focus on key performers or outliers.
How can you apply a relative date filter for the last 30 days in Power BI?
Power BI Filters enables relative date filtering for rolling time windows without manual date entry. You can set filters like 'last 30 days,' 'last quarter,' or 'year-to-date' that automatically adjust as time progresses. This approach keeps reports current without requiring daily filter updates, ideal for dashboards tracking recent trends.
How do you remove or clear filters from Power BI pages and visuals?
Power BI Filters provides straightforward removal and clearing of filters at both page and visual levels. You can clear individual filters from specific visuals or remove all filters from an entire page in one action. This flexibility helps reset reports to their default state or remove outdated filter constraints quickly.
What does batch applying filters with --no-sync control mean in power-bi-filters?
Power BI Filters allows you to batch apply multiple filter changes at once using the --no-sync flag for efficiency. Instead of applying each filter individually (which can trigger repeated refreshes), you stack multiple filter operations and apply them together, reducing processing time and improving performance on complex reports.
Can power-bi-filters include and exclude values in categorical filters?
Yes, Power BI Filters supports both include and exclude logic for categorical filters. You can whitelist specific values to display or blacklist values to hide them from your visual. This dual approach gives you flexibility in data restriction, whether you want to focus on a subset of categories or simply remove unwanted items from view.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
Power BI Filters Skill
Add and manage filters on PBIR report pages and visuals. Filters are stored
in the filterConfig section of page.json (page-level) or visual.json
(visual-level). No Power BI Desktop connection is needed.
Listing Filters
# List all filters on a page
pbi filters list --page page_abc123
# List filters on a specific visual
pbi filters list --page page_abc123 --visual visual_def456
Returns each filter's name, type, field, and scope (page or visual).
Categorical Filters
Include or exclude specific values from a column:
```bash
Include only East and West regions
pbi filters add-categorical --page page1 \ --table Sales --column
(truncated - see the full file via the links below)
File tree — 1 file
skills/power-bi-filters/SKILL.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Add and configure page-level or visual-level filters on Power BI reports”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Control which data appears on your Power BI report pages and visuals by adding categorical, TopN, and relative date filters through pbi-cli commands. Filters are stored directly in your report's configuration without requiring Power BI Desktop, and you can batch changes to minimize reloads.
Power BI Visuals enables you to create, bind, and manage 32+ visual types on PBIR report pages directly via pbi-cli, without needing Power BI Desktop. Supported visuals include bar charts, line charts, scatter plots, matrices, KPIs, gauges, and more, each configurable with custom positioning, sizing, and data binding. Bulk operations let you apply changes across multiple visuals at once by type or name pattern.
Power BI Pages lets you create, delete, and arrange report pages via command line, setting canvas dimensions, backgrounds, and visibility without opening Power BI Desktop. Manage bookmarks that preserve page state, and inspect drillthrough page configuration.
Manage pages and bookmarks in Power BI reports through command-line operations. Add or delete pages with custom dimensions, control visibility, set backgrounds, and organize page order—all without opening Power BI Desktop. Bookmarks capture page-level state for quick navigation.
Power BI Report scaffolds and manages PBIR projects from the command line using pbi-cli, handling folder structure creation, JSON validation, and live HTML preview. It integrates with Power BI Desktop to reload reports and supports batch operations with optional sync suppression.
Power BI Report lets you build PBIR projects from the ground up using pbi-cli, handling scaffolding, validation, live preview, and Desktop sync. Work with the folder-based JSON structure directly—no Desktop connection required for most tasks.
More skills power-bi-visuals (MIT) · Pbip (GPL-3.0) · Power BI Themes (MIT) · Power BI Custom Visuals (MIT) · Pbir Format (GPL-3.0)