Aggregate selected columns on chart

[amon151]

I'm not sure how to exactly ask this question so plese bear wtih me.

I have a column chart with bins like this...

What I want to do is select/highlight a group a columns in this chart and be able to see the sum of those values. For example, if the table below represented my column chart, I would select/highlight bins 2 & 3 and see a total of 13. I'm thinking this can be achieved using measures but I'm not sure where to start. Any ideas?

[Anonymous · Accepted solution]

Hi @amon151 ,

You can use slicer to achieve this:
Here is my sample data:

Then I use this DAX to create a measure:

SUM = SUM('Table'[Value])

I use ID and Value to create a column chart and put this measure into a card visual, then use Bin to create a slicer:

The final output is below:

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

[Daniel29195]

hello @amon151 

is this the requirement you want to achieve ? 

if yes, then power bi will automatically filters data and show the sum of the selected columns from the visual..

or am i missing something ? 

best regards,