Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tabular Editor - Change Default Summarization to Average for Multiple Columns

Hi All,   I m pivoting a table inside the report which results in more than 500 columns.   As there is no option to set default summarization for a table in PBI Desktop, I looked at tabular edito...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, Anonymous ;

    Is the above answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    5 years ago

    It was not about Saving the entries.

    The report probably reset Summarization everytime I pivoted the data.

    I therefore did a work around....

    1. Changed column names to number.

     

    2. Created an empty  table with numeric columns with  max columns that can be expected for the data. Disabled refresh for this table.

     

    3. Disabled Load for table that had to be pivoted.

     

    4. Appended pivoted table and dummy table together. Now since the column names wouldn't change, the Summarization set doesn't seem to change!!!

     

    Finally.. seems to be working!!

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi, Anonymous ;

You should click save(or ctrl+s)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It was not about Saving the entries.

    The report probably reset Summarization everytime I pivoted the data.

    I therefore did a work around....

    1. Changed column names to number.

     

    2. Created an empty  table with numeric columns with  max columns that can be expected for the data. Disabled refresh for this table.

     

    3. Disabled Load for table that had to be pivoted.

     

    4. Appended pivoted table and dummy table together. Now since the column names wouldn't change, the Summarization set doesn't seem to change!!!

     

    Finally.. seems to be working!!