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
How-to configure turning off summarization on all table columns of the model? In addition,configure turning off implicit measures on the visualizations as the default?
This would allow by exception setting the summarization on the column or changing a the column in the visualization to an implicit measure.
Shouldn't all measures be created explicitly?
Hi @pheller ,
For numeric fields, PBI Desktop will automatically aggregate, you just cancel it manually.
Why the Default Summarization Property in Power BI is So Important
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@pheller , Under the model tab, You can click on columns under advance option you have Summarize by. You can select multiple column using ctrl or shift and can change them together
First, make sure you have the latest version of Tabular Editor downloaded.
Next, restart Power BI and open your file.
Click External Tools and select Tabular Editor.
Open Advanced Scripting and paste the following code:
foreach (var c in Model.AllColumns)
{c.SummarizeBy = AggregateFunction.None ;}
Save the tabular editor file back the the database (ctrl-S)
Return to Power BI and Refresh your model.
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Thanks this worked for me 🙂
This is excellent in terms of achieving the default value of "do not summarize" using the Tabular Editor.
You need a way to turn off summary in the visualization to avoid implicit measures as default. They should be by exception (turning them on manually) and eventually replacing them with explicit measures.
Thank you for your suggestion. I used Google's translator to respond in Spanish.
English:
This is excellent as far as accomplishing the default value of "do not summarize" using the Tabular Editor.
Need a way to turn off summarize in the visualization to avoid implicit measures as the default. They should be by exception (manually turning them on) and eventually replacing them with explicit measures.
Thank your suggestion. I used google translate to respond in Spanish.
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 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
112 | |
99 | |
69 | |
67 |