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.

Anonymous's avatar
Anonymous
Not applicable
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.