Active Filters Card Visual
Show Applied Selections
Build
Overview
Features
Prompts
Troubleshooting
Key Features
Your report has 6 slicers. A user applies filters and shares a screenshot — but which filters were active? Building a dynamic card that shows "Region: North America, Period: L3M" requires scanning every slicer, writing ISFILTERED/CONCATENATEX DAX for each one, and creating a card visual with formatting. This skill scans the page, generates the DAX, and places the card automatically.
How it works
Type /active-filters-card, select your page, and the skill builds the display:
Scans all slicers on the page — identifies table, column, data type
Filters out field parameters and permanent filters
Generates a display measure using ISFILTERED checks and CONCATENATEX for text columns or MIN/MAX for date ranges
Creates a blank measure for the card visual
Places a card visual on the page with auto-positioned layout
What you get
Disconnected DATATABLE — with FieldName, Category, SortOrder, and CategorySort columns
Updated measures — CONCATENATEX pattern for clean multi-selection display
SWITCH dispatcher — maps selected field name to the correct measure
Rebuilt matrix — rows show category labels, values show the dispatcher measure
Category slicer — dropdown bound to the category column
Explore more in this category
Absolute / Percentage Toggle
Build
Add a two-button tile slicer to any chart that switches between absolute values and a percentage variant, with a dynamic format string and auto-derived chart title.
Clone Page
Build
Clone any report page with all visuals, bookmark navigators, interactions, and drillthrough bindings as a fully independent copy.
Convert to Trendline
Build
Add formatted data labels, markers, area shading, and a canvas tooltip to line chart visuals.
Create Tooltip
Build