Forum Discussion
Dynamic display names of parameter fields
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 ...
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"
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