Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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.
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!!
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.
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.
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!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |