Hi @powerbiexpert22 ,
I get that you want to display only related measures or dimensions dynamically
Idea
Create a lightweight dimension selector and a measure↔dimension mapping table, then expose every report measure through a small wrapper measure that returns the real value only when the selected dimension is valid; otherwise it returns BLANK().
Steps
1. Create a disconnected slicer for Dimension selection
DimSelector = DATATABLE(
"Dimension", STRING,
{ {"Product"}, {"Customer"}, {"Date"} }
)Use DimSelector[Dimension] as the slicer users pick.
2. Create a mapping table (which measures are valid for which dims)
MeasureDimensionMap = DATATABLE(
"MeasureKey", STRING,
"Dimension", STRING,
{
{"ProfitMargin","Product"},
{"Revenue","Product"},
{"Revenue","Customer"},
{"OrderCount","Customer"},
{"Revenue","Date"}
}
)
3. Create a wrapper measure for each business measure
Display_ProfitMargin =
VAR selDim = SELECTEDVALUE( DimSelector[Dimension] )
VAR allowed =
COUNTROWS(
FILTER(
MeasureDimensionMap,
MeasureDimensionMap[MeasureKey] = "ProfitMargin" &&
MeasureDimensionMap[Dimension] = selDim
)
) > 0
// If no dimension selected, you may choose to show or hide; below shows when selDim blank
RETURN
IF( selDim = BLANK() || allowed, [Profit Margin], BLANK() )Put Display_ProfitMargin (not the raw measure) into your Measure field-parameter or table values.
4. Wire wrappers into the Measure Field Parameter
If you already use a Field Parameter that controls which measures appear, replace the entries for measures with their wrapper measures. That way the field parameter continues to control visibility, but content is conditional on the selected dimension.
5. User experience / visuals
When the user selects Product the Display_ProfitMargin returns real values.
When they select Customer or Date, the wrapper returns BLANK() → table shows empty cells (effectively “nothing”).
If you want the entire column removed instead of blank cells, you’d need to remove the measure from the parameter dynamically (not natively supported) or use a calculation-group / Tabular Editor approach (advanced).
Optional advanced: hide entire column
- If blanks are not good enough and you must remove the column from view, consider:
- A calculation group with SELECTEDMEASURE() logic (Tabular Editor), or
- Programmatic parameter rebuild (Power Query / JSON) — both are advanced and require model-editing tools.
Quick checklist before you finish
- Ensure your wrappers are used everywhere the measure is presented (Parameter, Cards, tooltips).
- Test multi-select on DimSelector — the wrapper logic counts a match per selected dimension (adjust logic if you need ANY vs ALL).
- If the matrix shows headers for blank columns and you want them less visible, apply conditional formatting (font color/opacity) to reduce visual noise.
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀 [Explore More]
