Forum Discussion
"Do Not Summarize" missing
It is only avaibale in PowerView (ie : Excel)
Workaround : flag colum as text in your query
"dirty" workaround : if you need to keep your column as number for other calculation, duplicate the column in your query and flag it as text (remember to order it by the numeric column ;-) )
- No longer! You'll now see that option in Power BI Desktop as well!
I haven't updated to the latest version and I still have it available in my desktop version. If I go over to the data model and click on one of my measures or on any item with the Sum symbol, I can go up to the top under the Data Tools Tab for Modeling and in the Properties box see "Default Summarization: Sum " with a drop down arrow. Then I click the drop down arrow it offers several aggregations along with the "Do not summarize."
If it is not there for you, it must have been lost in the most recent upgrade.
I can set the Default Summarization to "Don't summarize", but it still doesn't seem to allow a scatter plot that plots every item in a field. When creating a scatter plot with 'don't summarize' default for a field, it defaults to 'count' and 'don't summarize' on the Axis menu isn't there. I'm assuming "don't summarize" isn't supported for lots of specific charts. I can get 'don't summarize' to work on the same data in a table.
Does anyone know how to get it in a scatter plot?
