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

[iGi]

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: 

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

[v-haibl-msft · Accepted solution]

@iGi

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

 

Best Regards,

Herbert

[iGi]

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?

[Greg_Deckler]

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.

[iGi]

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. 

[Greg_Deckler]

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