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 ...
  • 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