Matrix: change measure name based on parameter selection.

[Bobv013]

Hi all,

I've created a matrix table which includes a measure and a parameter connected to it. 

However whenever a certain parameter is selected I want the measure to not say 'geselecteerde parameter' (selected parameter in english) but the actual name of the selected parameter. The parameter is selected through a slicer. I can't figure out how to do this. 

Below the matrix table: 

measure:

Parameter:

In short whichever parameter is selected in the slicer, that name should be the name in the matrix. 

Is there a way to make this happen?

Thanks in advance for any help.

[v-dineshya · Accepted solution]

Hi @Bobv013 ,

Thank you for reaching out to the Microsoft Fabric Community forum.

1. Create a dynamic label measure

Selected Parameter Label =
VAR SelectedParam = SELECTEDVALUE('Selectie Parameter'[Selectie Parameter])
RETURN
SWITCH(
SelectedParam,
"Bruto_geboekte_premie_os", "Bruto geboekte premie os",
"Bruto_verdiende_premie", "Bruto verdiende premie",
"Netto_geboekte_premie_os", "Netto geboekte premie os",
"Netto_verdiende_premie", "Netto verdiende premie",
"Geselecteerde Parameter"
)

2. Replace "Geselecteerde Parameter" with this measure Geselecteerde Parameter

To replace that label dynamically, In your matrix visual, remove the existing static row name. Add a new calculated measure placeholder row.

Dynamic Value Measure =
VAR SelectedParam = SELECTEDVALUE('Selectie Parameter'[Selectie Parameter velden])
RETURN
CALCULATE(SELECTEDPARAMETERMEASURE)

Note: Replace SELECTEDPARAMETERMEASURE with your measure switch depending on the parameter selected. Use the Selected Parameter Label as a row value instead of hardcoding “Geselecteerde Parameter”.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-dineshya]

Hi @Bobv013 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[v-dineshya]

Hi @Bobv013 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[v-dineshya]

Hi @Bobv013 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[burakkaragoz]

Hi @Bobv013 ,

What you’re asking for—dynamically changing the measure name in the matrix based on the selected parameter—is a common challenge in Power BI. By default, Power BI doesn’t allow dynamic renaming of measure titles in visuals. However, there are some workarounds you can try to achieve a similar effect:

Option 1: Use Field Parameters (Dynamic Titles in Matrix Columns)

• With field parameters, the column/measure name shown in the matrix will be the name of the field in your parameter table.
• Make sure your parameter table (created with the Field Parameter feature) has the display names you want to see.
• When you select a parameter in the slicer, the corresponding display name will be shown in the matrix.

Option 2: Dynamic Titles Above the Matrix

• While you can’t change the measure name within the matrix, you can use a dynamic card or text box above the matrix to display the selected parameter.
• Create a measure like this:
  dax

  Selected Parameter Name = SELECTEDVALUE('ParameterTable'[ParameterName])

• Add a Card visual to your report and display this measure. Position it above or near the matrix for context.

Option 3: Unpivot Your Data and Use Categories

• If your table structure allows, you could unpivot your data so that all possible measures are values in a single column, then use the parameter as a category in the matrix. This way, the row/column headers will reflect the selected parameter.

Important Note:
Currently, Power BI does not support fully dynamic column/measure names inside visuals based on slicers or selections. The above options help you get as close as possible to your goal.

References:

• Microsoft Power BI – Field Parameters
• Dynamic Titles in Power BI

If you need sample DAX code or a step-by-step on any of these workarounds, let me know which option you’d like to try.

If this helps, please give kudos and mark this as a solution to help others in the community.

Thank you!