Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Variable in column name in summarize table

I am creating a calculated table by summarizing date, country, branch and sales amount from Table Sales   Branch_Sales_calc = var branch =  'Parameter'[Branch]  -- value is from query parameter ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Anonymous Currently it is not supported to change the column name dynamically with the parameter.

     

    As a workaround, I suggest using fixed "Sales" or "Total Sales" as the name of this column to indicate what this column's data describes. Then format the visual's title conditionally with the field 'Parameter'[Branch] to let users know which branch this data represents for.

     

    Kindly let me know if this helps.

     

    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , I doubt you can use a slicer value or parameter in a new table creation

 

also try changing var like and try

var branch =  max('Parameter'[Branch] )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have tried, it does not work. 

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Anonymous Currently it is not supported to change the column name dynamically with the parameter.

     

    As a workaround, I suggest using fixed "Sales" or "Total Sales" as the name of this column to indicate what this column's data describes. Then format the visual's title conditionally with the field 'Parameter'[Branch] to let users know which branch this data represents for.

     

    Kindly let me know if this helps.

     

    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.