Field Parameters currently treat all selected columns as a flat list, ignoring any hierarchical relationships that exist between those columns in the data model. This prevents the creation of asymmetric reports with proper grouped/parent-child structures. This feature request asks for Field Parameters to automatically detect and honor existing hierarchies between the columns included in the parameter, enabling grouped asymmetric reporting without requiring any complex and slow workarounds like switch statements in DAX and disconnected tables. What is an Asymmetric Report? An asymmetric report displays different measures or data combinations for different columns . For example: Budget vs. Actuals by Time Period: 2024 ├─ Budget ├─ Actuals └─ Variance 2025 ├─ Budget └─ Forecast (no Actuals yet) Proposed Solution Instead of omplex workarounds, make Field Parameters automatically detect and respect hierarchical relationships when used in the Columns area of a matrix visual How It Would Work: 1. Enhanced Field Parameter Definition with Parent Column: Users define parent-child relationships directly in the Field Parameter using a "Parent" column: DAX Year Metrics = DATATABLE( "Column Header", STRING, "Field", STRING, "Sort", INTEGER, "Parent", STRING, { {"2024", "", 1, ""}, {"Budget", "[Budget]", 2, "2024"}, {"Actuals", "[Actuals]", 3, "2024"}, {"Variance", "[Variance]", 4, "2024"},
{"2025", "", 5, ""}, {"Budget", "[Budget]", 6, "2025"}, {"Forecast", "[Forecast]", 7, "2025"},
{"2026", "", 8, ""}, {"Budget", "[Budget]", 9, "2026"} }) Where: Column Header: Display name for the column Field: Measure reference (empty for parent headers that are just labels) Sort: Order of columns Parent: References the "Column Header" value of the parent (empty = top-level) 2. Display in Matrix Visual Columns: When this Field Parameter is added to the Columns area of a matrix, it would display as: Products on Rows | 2024 | 2025 | Budget | Actuals | Variance | Budget | Forecast Product A | 100 | 95 | -5 | 110 | 105 Product B | 200 | 210 | +10 | 220 | 215 With proper: Parent column headers spanning their children Each parent column having its own unique set of child columns True asymmetric column structure 3. Performance: No performance degradation for flat Field Parameters Hierarchical column Field Parameters perform similarly to manually created column structures
... View more