topic Dynamic display names of parameter fields in DAX Commands and Tips

Dynamic display names of parameter fields

rjobaan — Wed, 17 Aug 2022 14:56:06 GMT

I created a parameter field to show On Y-axes of a graph:

Y-Axis = {

("Gross", NAMEOF('FCT_Actual'[_REF Actual - Quantity]), 0),

("Budget", NAMEOF('FCT_Budget'[Budget]), 1)

}

The measure _REF Actual - Quantity is showing one measure based on a slicer (Gross, Nett)

_REF Actual - Quantity =

IF (

HASONEVALUE(Switch_Gross_Nett[Gross Nett]),

SWITCH(

VALUES(Switch_Gross_Nett[Gross Nett]),

"Gross", [_REF Gross Quantity],

"Nett", [_REF Nett Quantity]

)

The measure works fine

But now If I add the parameter field into graph its showing "Gross" as display name even when Nett is selected

So I thought let add some code to the parameter field to make the name dynamic

I only changed the first part

(if(SELECTEDVALUE(Switch_Gross_Nett[Gross Nett])="Gross","Gross","Nett")", NAMEOF('FCT_Actual'[_REF Actual - Quantity]), 0),

But its not working. I know an "If-statemnet" works so probably the selectedvalue does not work.

Any one any idea how to solve this?

Re: Dynamic display names of parameter fields

amitchandak — Wed, 17 Aug 2022 16:17:00 GMT

rjobaan , I used code to show selected value in this blog

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

What is selected = maxx(filter(‘Axis Slicer’, ‘Axis Slicer’[Axis Slicer Order]= SELECTEDVALUE(‘Axis Slicer’[Axis Slicer Order])),’Axis Slicer’[Axis Slicer])

Re: Dynamic display names of parameter fields

rjobaan — Thu, 18 Aug 2022 08:24:21 GMT

I tried that, but it does not work

i changed (if(SELECTEDVALUE(Switch_Gross_Nett[Gross Nett])="Gross","Gross","Nett")", NAMEOF('FCT_Actual'[_REF Actual - Quantity]), 0),

into

(if(maxx(filter(Switch_Gross_Nett, Switch_Gross_Nett[Gross Nett]= SELECTEDVALUE(Switch_Gross_Nett[Gross Nett])),Switch_Gross_Nett[Gross Nett])="Gross","Gross","Nett"), NAMEOF('FCT_Actual'[_REF Actual - Quantity], 0)

it keeps showing "Nett" even if I change to "Gross"

Re: Dynamic display names of parameter fields

Anonymous — Wed, 07 Sep 2022 07:43:54 GMT

Hi rjobaan,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Dynamic display names of parameter fields

oduc78 — Fri, 12 Jan 2024 13:12:16 GMT

Hello, I've got a similar issue but I haven't been able to find a solution. I created a new post: SELECTEDVALUE doesn't work to add a dynamic header to Field Parameters. Maybe comparing similar problems can help us solve them, let me know.

Olivier.