Forum Discussion

j_ocean's avatar
j_ocean
Icon for Helper V rankHelper V
2 years ago
Solved

Field Parameter Columns: What does each do and which can I hide?

If you use the feature to create a field parameter it returns a table with columns Parameter, Parameter Fields, and Parameter Order.

 

"Order" is self explanatory but between "Parameter" and "Parameter Fields," what is the difference and should I direct report builders to one or the other? 

 

In Data View "Fields" appears to be the fully-defined (table.column) equivalent of the "Parameter", but regardless of which I put in a visual the values and filter behavior seem to be the same, but both get the shorter "Parameter" label. So I'm guessing "Parameter Fields" is used internally and I can safely hide it. Is this correct or am I buying myself trouble?

Need Help
  • swikritee_p's avatar
    swikritee_p
    2 years ago

    The name in the parameter column will come, Other columns are hidden by default

     

    Parameter = {
        ("State", NAMEOF('Geography'[State]), 0),
        ("City", NAMEOF('Geography'[City]), 1)
    }

     

2 Replies

  • swikritee_p's avatar
    swikritee_p
    Icon for Resolver II rankResolver II
    2 years ago

    The name in the parameter column will come, Other columns are hidden by default

     

    Parameter = {
        ("State", NAMEOF('Geography'[State]), 0),
        ("City", NAMEOF('Geography'[City]), 1)
    }

     

    • j_ocean's avatar
      j_ocean
      Icon for Helper V rankHelper V
      2 years ago

      They weren't hidden by default, perhaps this was a change with a newer version than what I have. The screen grab calrifies the intent though, thanks.