Forum Discussion
"Do not summarize" missing
Hi!
Is there a reason why I can't select "Do not summarize" for any of my number fields?
The data I'm using here comes from an Azure SQL database.
Does this feature exist for anybody else or is it disabled site-wide for some reason?
Best regards,
Tom Kaczmarczyk
tkaczmarczyk unfortunately, unlike Power Pivot in Excel, the Desktop does not support "Do not summarize" right now. The only way to get rid of those Sum symbols is to mark your columns as text instead of number (so you can have your Year column of data type Text and not Whole Number).
Not elegant by any means but helps in the short run until it gets fixed, hopefully soon...
7 Replies
tkaczmarczyk unfortunately, unlike Power Pivot in Excel, the Desktop does not support "Do not summarize" right now. The only way to get rid of those Sum symbols is to mark your columns as text instead of number (so you can have your Year column of data type Text and not Whole Number).
Not elegant by any means but helps in the short run until it gets fixed, hopefully soon...
Doesn't exist in the service.
Hmm. But I do see that the feature in itself exists: https://support.powerbi.com/knowledgebase/articles/471200-change-the-aggregation-in-a-chart-sum-average-m.
And I arrive at the exact same result when using Power BI Desktop - can't treat numeric fields in any way that's not summarized, rendering a lot of scenarios unavailable (e.g. it's impossible to generate a scatter plot).
That link didn't work, but yes, it exists in Excel and Desktop.
