Forum Discussion

amon151's avatar
amon151
Frequent Visitor
2 years ago
Solved

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 a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Daniel29195
Community Champion
2 years ago

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,