Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |