power-bi-filters

# 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 ```bash # 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 Region \ --values "East" "West" ``` The filter appears in the page's `filterConfig.filters` array. Power BI evaluates it as an IN-list against the specified column. ## TopN Filters Show only the top (or bottom) N items ranked by a measure: ```bash # Top 10 products by revenue pbi filters add-topn --page page1 \ --table Product --column Name \ --n 10 \ --order-by-table Sales --order-by-column Revenue # Bottom 5 by quantity (ascending) pbi filters add-topn --page page1 \ --table Product --column Name \ --n 5 \ --order-by-table Sales --order-by-column Quantity \ --direction Bottom ``` The `--table` and `--column` define which dimension to filter (the rows you want to keep). The `--order-by-table` and `--order-by-column` define the measure used for ranking. These ca...