Display only related measures or dimensions dynamically in table visual

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]

Hi powerbiexpert22 ,

You can create a flag measure to control the measure slicer like below

Flag = IF(
    SELECTEDVALUE('Dimensions'[Dimensions Fields])="'Orders'[Order Date]" 
    && SELECTEDVALUE('Measures 2'[Measures Fields])="'Orders'[profit margin]",1,0
)

add this to your measure slicer and add condition Flag is 0.this will not show profit margin when

date is selected(as an example).

Please mark it as resolved once confirmed.

Thanks and Regards,

Praful

Hi GrowthNatives ,

i created a sample power bi report with your solution implemented , it is not working expected , please see below file

https://drive.google.com/file/d/1ZjwAcSfRHM78ZtFkEGXHz1VrD0rCBVRg/view?usp=drive_link

Hi powerbiexpert22 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

powerbiexpert22 Hey,

I will follow below steps 

1. I will use below field parameter -

Dimension Field Parameter: Include Product, Customer, and Date dimensions.
Measure Field Parameter: Include Profit Margin and any other relevant measures.

2. I will Configure few Slicers:

- Dimension Slicer: Connect the slicer to the Dimension Field Parameter.
- Measure Slicer: Connect another slicer to the Measure Field Parameter.

3. Use DAX to create a calculated measure that checks the selection:

DisplayMeasure =
IF(
SELECTEDVALUE(DimensionParameter[Value]) = "Product" &&
SELECTEDVALUE(MeasureParameter[Value]) = "Profit Margin",
[Profit Margin],
BLANK()
)

I will above mentioned steps to troubleshoot and solve your problem.

Hi powerbiexpert22 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you