Forum Discussion
Roisin
3 years agoNew Member
How to switch Default Summation off in Power BI
Hi all, To be clear, this relates to Power BI online, not the Desktop version. Does anybody know how to switch Default Summation off in Power BI? Halfway through my graphing it begain including '...
- 3 years ago
Hi Roisin
Most visuals require the value fields to be aggregated. For numeric fields, it usually takes Sum by default and adds "Sum of" to the name. You can rename it easily by right clicking on the field and select Rename for this visual.
For the visuals that support unaggregated fields (Table, Multi-row Card), you can select "Don't summarize" option to show unaggregated values and it will remove "Sum of" from the name.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. - 3 years ago
Thank-you so much! this did the trick to rename it, as the option of 'dont summarize' is not in any dropdown.
Syndicate_Admin
Administrator
2 years agoI don't have that option for do not summarize. What am I missing?