Active Filters Card Visual

Back

Active Filters Card Visual

Show Applied Selections

Build

Overview

Features

Prompts

Help

Key Features

omeone slices the report six ways, screenshots a number, and asks why it looks off — but the screenshot doesn't show which filters were on. A card that spells out the active selections fixes that, except building one by hand means scanning every slicer, writing filter-detection DAX for each column, formatting it readably, and dropping a card on the page. And there's judgement involved: a parameter slicer that only drives a measure shouldn't be listed as a page filter, while a report-level filter should. This skill works out which filters actually affect the page, writes the DAX, and places the card for you — bold headers, selected values, and a min–max range for dates — run it with /active-filters-card.

How it works

Type /active-filters-card, point it at your page, answer one question, and the skill builds the card:

Asks one thing — which display folder the measures should live in (default _ActiveFilters)
Scans the page — finds every slicer and works out which ones actually filter the page: connected-table slicers and report-level filters are in; parameter (disconnected) slicers, inverted-selection slicers, and field parameters are left out
Writes the DAX — a display measure showing each active filter as a bold header with its selected values, a min–max range for dates, and your "Nothing Selected" text when the page is clear
Places the card — a card visual dropped into free space on the page (or updated in place if one already exists)
Shows you a summary — a table of every slicer on the page, whether it's in the card and why — so you can adjust the set and re-run

What you get

A filters card — a card visual on the page listing the active selections, or your "Nothing Selected" text when nothing is applied
A display measure — the DAX behind it, with bold Unicode headers, selected values, and a min–max range for date filters
A review summary — a table of every slicer on the page, in-card or not, with the reason for anything excluded
Per-page measures — each page gets its own card and measure, so you can put one on several pages and each shows its own filters

Explore more in this category