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

# 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:

# 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:

# 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 can be different tables -- for example, filtering Product names by Sales revenue.

Direction defaults to Top (descending -- highest N). Use --direction Bottom for ascending (lowest N).

Relative Date Filters

Filter by a rolling window relative to today:

# Last 30 days
pbi filters add-relative-date --page page1 \
    --table Calendar --column Date \
    --period days --count 30 --direction last

# Next 7 days
pbi filters add-relative-date --page page1 \
    --table Calendar --column Date \
    --period days --count 7 --direction next