Forum Discussion
Solved
Don't Summarize not working
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 ...
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
Super User
Super UserYou are putting the year into the Axis field yes?