Don't Summarize not working

[Tinkerman]

I am trying to create a basic visualisation that shows total profit by year in a column graph. However, when I drop the year field into the graph it is summing the values even though I have selected "don't summarize".

It doesn't seem to matter how I approach it, the result is always the same

Does anybody have a solution or a suggestion as to how to make this work?

[V-lianl-msft · Accepted solution]

Hi @Tinkerman ,

For some visuals, if you don't want it aggregated, put it in the AXIS or LEGEND fields if they are available.  If you drag it to VALUES, the visual may try to aggregate it for you.

If there is no unique value in the key column of the visual, the aggregated value will be displayed for the numerical value. In some cases, we can change the aggregation through the DAX formula to display the desired value.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

You are putting the year into the Axis field yes?