- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
"Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-13-2015 07:30 AM
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
Solved! Go to Solution.
Accepted Solutions
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-16-2015 02:20 PM
@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...
All Replies
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-13-2015 08:07 AM
Doesn't exist in the service.
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-13-2015 08:31 AM
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-aver...
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).
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-13-2015 08:46 AM
That link didn't work, but yes, it exists in Excel and Desktop.
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-13-2015 11:58 PM
I agree rendering many situations is impossible, just speaking about simple scenario when you want to plot days of month on x axis.
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-14-2015 04:55 AM
Here is the idea for it, can't believe it only had 1 vote when I went to it:
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-14-2015 07:35 AM
Oops. Had a period at the end of the link. This one should work better: https://support.powerbi.com/knowledgebase/articles/471200-change-the-aggregation-in-a-chart-sum-aver... - and this implies that this feature exists somewhere, but I can see it neither in the browser-based Power BI service nor in Power BI Desktop:
Do you see that option for your data sets? Perhaps it's a bug with the way Power BI handles Azure SQL.
Re: "Do not summarize" missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-16-2015 02:20 PM
@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...