Forum Discussion
How to switch Default Summation off in Power BI
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.Thank-you so much! this did the trick to rename it, as the option of 'dont summarize' is not in any dropdown.
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.
hi how can i stop summing my column
Thank-you so much! this did the trick to rename it, as the option of 'dont summarize' is not in any dropdown.
Hi,
I got to this point, but it's just renaming the axis and still summing up the values under it. I'm using desktop Power BI. How can I show each values separately or get rid of the sum option?
Thank