Forum Discussion

Tinkerman's avatar
Tinkerman
New Member
5 years ago
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 ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.