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
Install
julianobarbosa/claude-code-skills/power-bi-filters · repository language: Python
git clone https://github.com/julianobarbosa/claude-code-skills
cp -r claude-code-skills/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 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)
Read as markdown · JSON record · Browse the source repository
File tree — 1 file
skills/power-bi-filters/SKILL.md