Forum Discussion

rjobaan's avatar
rjobaan
Frequent Visitor
4 years ago

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 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?
 

4 Replies

    • rjobaan's avatar
      rjobaan
      Frequent Visitor
      4 years ago

      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"
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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