cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

"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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Participant
Power Participant

Re: "Do not summarize" missing

@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...

View solution in original post

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: "Do not summarize" missing

Doesn't exist in the service.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: "Do not summarize" missing

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). 

Highlighted
Super User IV
Super User IV

Re: "Do not summarize" missing

That link didn't work, but yes, it exists in Excel and Desktop.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Advocate II
Advocate II

Re: "Do not summarize" missing

I agree rendering many situations is impossible, just speaking about simple scenario when you want to plot days of month on x axis.

Super User IV
Super User IV

Re: "Do not summarize" missing

Here is the idea for it, can't believe it only had 1 vote when I went to it:

https://support.powerbi.com/forums/265200-power-bi/suggestions/9208014-power-pivot-do-not-summarize-...

 

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: "Do not summarize" missing

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:

 

 Power BI Desktop.PNG

 

 

Do you see that option for your data sets? Perhaps it's a bug with the way Power BI handles Azure SQL.

Highlighted
Power Participant
Power Participant

Re: "Do not summarize" missing

@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...

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors