Forum Discussion
Aggregate selected columns on chart
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?
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.
2 Replies
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.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,
