My bar graphs do not show the aggregation of sum

[Ariba1]

when I select these 3 bars it doesn't show me the total sum. But in Tableau when I do that it adds up and show me the sum. How can I do that in PowerBi? 

[Anonymous · Accepted solution]

Hi @Ariba1 ,

As @ChiragGarg2512  said, you can create a measure.

Total = CALCULATE(SUM('Table'[value]),ALLSELECTED('Table'))

You can place this measure on a card visual object.

Or you can use a slicer. Then turn on "custom label" on the bar chart visual object.

Please refer to my pbix file. page1 and page2.

Best Regards,

Neeko Tang

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

[ChiragGarg2512]

@Ariba1 , After applying the values in a column chart, right click on y-axis parameter and apply sum. If that doesn't solve the problem create a measure [measure = sum(`y-axis parameter`)]. 

For any other issue send an image of how does the graph look in pbi.

Thank you