Reply
iGi Frequent Visitor
Frequent Visitor
Posts: 15
Registered: ‎09-01-2016
Accepted Solution

"Value" field defaulting to "Sum" instead of "Count"

Hello, 

 

Ever since around the beginning of the year, what's been happening is that the Value field appears to be defaulting to Sum rather than Count, as it used to. 

 

The default looks like this and requires two extra clicks for each visual: 

PowerBI Value Field Default.png

 

I'm absolutely certain that I didn't need to change the Value field before. Can anyone else confirm? 


Accepted Solutions
Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

Re: "Value" field defaulting to "Sum" instead of "Count"

@iGi

 

Please try to change the default summarization in the Modeling tab of Power BI Desktop.

 

Value field defaulting to Sum instead of Count_1.jpg 

 

Best Regards,

Herbert

View solution in original post


All Replies
Super User
Posts: 10,599
Registered: ‎07-11-2015

Re: "Value" field defaulting to "Sum" instead of "Count"

In my experience, Text fields default to Count, numeric fields default to Sum.


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

Proud to be a Datanaut!


iGi Frequent Visitor
Frequent Visitor
Posts: 15
Registered: ‎09-01-2016

Re: "Value" field defaulting to "Sum" instead of "Count"

Thanks @Greg_Deckler. I'm importing from an Excel document in this scenario where the ID column is just set to "general" (each ID is a number). I've changed that to a simple "number" format in Excel, imported anew and still get Sum as the default. 

 

Any other ideas? Maybe I missed something. 

Super User
Posts: 10,599
Registered: ‎07-11-2015

Re: "Value" field defaulting to "Sum" instead of "Count"

Edit your query and specifically set the column to Text in your query. Or, you can go into your data model and change the type to Text there. Or, are you doing this all in the service? One final way would be to put something that is obvioulsy text as a row in that table like "a" instead of a number and that will force it to text.


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

Proud to be a Datanaut!


Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

Re: "Value" field defaulting to "Sum" instead of "Count"

@iGi

 

Please try to change the default summarization in the Modeling tab of Power BI Desktop.

 

Value field defaulting to Sum instead of Count_1.jpg 

 

Best Regards,

Herbert

Highlighted
iGi Frequent Visitor
Frequent Visitor
Posts: 15
Registered: ‎09-01-2016

Re: "Value" field defaulting to "Sum" instead of "Count"

That did the trick. Thank you very much. Is there any way to set is as the default globally so that it applies each time I open PowerBI?