Tabular Editor - Change Default Summarization to Average for Multiple Columns

[modi123p]

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 editor to set the default by selecting all columns as a single operation.

Tabular editor does not show any error and I can see the summarization set to average. However the changes are not saved.

Wondering if this is something supported in the editor or if I need to update to the latest version? 

I use version 2.14.0

Any help would be appreciated.

I need to work on 5 such reports. If there is any other tool which can help, please suggest the same. 

Thanks,

Mannu  

[v-yalanwu-msft · Accepted solution]

Hi, @modi123p ;

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.

[v-yalanwu-msft · Accepted solution]

Hi, @modi123p ;

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.

[v-yalanwu-msft]

Hi, @modi123p ;

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.

[modi123p · Accepted solution]

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