Power BI Filters
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 Filters lets you add, remove, and manage page and visual-level filters on PBIR reports via pbi-cli.
AI-generated summary based on this skill's SKILL.md
Install
MinaSaad1/pbi-cli/power-bi-filters · repository language: Python
git clone https://github.com/MinaSaad1/pbi-cli
cp -r pbi-cli/src/pbi_cli/skills/power-bi-filters ~/.claude/skills/power-bi-filtersFrequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I add filters to Power BI reports using Power BI Filters?
Power BI Filters lets you add categorical, TopN, and relative date filters directly to your report pages and visuals through pbi-cli commands. Filters are stored in your report's configuration without requiring Power BI Desktop, so you can manage them programmatically and apply changes efficiently.
Can Power BI Filters help me filter top 10 products by a specific measure?
Yes. Power BI Filters supports TopN filtering, allowing you to rank and display only the top or bottom N items by any measure. For example, you can filter to show your top 10 products by revenue or bottom 5 by cost, helping you focus on the most relevant data.
How do I set up a power bi relative date filter for rolling time windows?
Power BI Filters includes relative date filtering capabilities for rolling time windows. You can configure filters for periods like the last 30 days, last 7 days, or other rolling intervals, making it easy to maintain dynamic date-based views without manual updates.
What's the best way to exclude values from a Power BI visual?
Power BI Filters lets you exclude specific values through categorical filtering. You can restrict data in any visual by removing unwanted categories or regions, ensuring only the data you need appears in your reports.
Can I batch apply multiple filters efficiently in Power BI Filters?
Yes. Power BI Filters supports batch application of multiple filters with sync control, allowing you to apply several filter changes at once and minimize report reloads. This is especially useful when managing complex filter configurations across multiple visuals.
How do I clear or remove filters from my Power BI report?
Power BI Filters provides commands to remove or clear filters from your reports. You can delete specific filters or clear all filters from a page, giving you full control over your report's filtering state at any time.
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)
Read as markdown · JSON record · Browse the source repository
File tree — 1 file
src/pbi_cli/skills/power-bi-filters/SKILL.md