Consider Merging Cards into a Matrix
What It Detects
Section titled “What It Detects”This flag identifies report pages where multiple single-measure Card visuals share the same filter context. Each Card likely generates a separate DAX query. Consider replacing these Cards with a single Matrix visual and placing the measures in the Values field to reduce query count and improve performance.
Why It Matters
Section titled “Why It Matters”- Excessive DAX queries — Every Card visual generates its own DAX query against the dataset. A page with 10 Cards means 10 separate queries, even when they share the same filter context.
- Slower page rendering — More queries means longer page load times, especially on large datasets or when slicers are applied.
- Simplified maintenance — A single Matrix visual with multiple measures is easier to format, align, and update than a collection of individual Cards.
- Better user experience — A Matrix provides a more compact and scannable layout for displaying multiple KPIs side by side.
Trigger Conditions
Section titled “Trigger Conditions”A page is flagged when:
- There are multiple Card visuals on the same report page.
- The Card visuals share the same filter context (e.g., same slicers, same page-level filters).
- Each Card displays a single measure.
Threshold: ≥ 3 single-measure Card visuals sharing the same filter context on a page (default).
Output
Section titled “Output”| Field | Description |
|---|---|
reportName | Report name |
pageName | Page name |
cardCount | Number of single-measure Card visuals on the page |
measures | List of measures displayed across the Cards |
workspaceName | Workspace name |
Notes and Edge Cases
Section titled “Notes and Edge Cases”- Intentional design — Some report designs intentionally use individual Cards for visual emphasis or conditional formatting per KPI. Evaluate whether consolidation fits the design intent.
- Different filter contexts — Cards that are filtered differently (e.g., one Card shows current year, another shows previous year) should not necessarily be merged.
- Custom Card visuals — Third-party Card visuals may not be detected by this flag.
Related Flags
Section titled “Related Flags”- Excessive Visuals — High total visual count on a page, including Card visuals.
- Non-Data Visuals — Decorative visuals that don’t display data.