Reconfig a Slicer Button to add multiple Cells to Dynamic Pivot Chart for a Bar Chart

[manbearpig2020]

Hello folks,

You all were very helpful before, so I wanted to take the time to ask the group how to best tackle a project I am dealing with.

I am trying to get a dashboard working with Slicers on it. Not a big deal really but I am having trouble configuring it properly with stacked columns.




So I am trying to add in a column of data with a single slicer click onto multiple rows. It instead wants to add each individual cell in there. That is confusing the alternative lacks the dynamic touch.

I want to create stacked bar chart like this


Row B XXXXXXXXX!(Slicer1)YYY!YYY!YYY!YYY!YYY!(/Slicer1)

Row C XXXXXXXXX!XXXXXXXXX!(Slicer1)YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!(/Slicer1)

Row D XXXXXXXXX!XXXXXXXXX!XXXXXXXXX!(Slicer1)YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!(/Slicer1)


..Instead its acting like this....


Row B XXXXXXXXX!(Slicer1)YYY!YYY!YYY!YYY!YYY!(/Slicer1)

Row C XXXXXXXXX!XXXXXXXXX!(Slicer2)YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!(/Slicer3)

Row D XXXXXXXXX!XXXXXXXXX!XXXXXXXXX!(Slicer3)YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!YYY!(/Slicer3)


It also will exclude anything that isn't selected by Slicer. So, if I clicked Slicer1 only Row A would show up properly. 2 and 3 would be excluded.
The only way it has looked correct is to use the Sum of that (Greco Sigma symbol), but that isn't dynamic.

Data for Example

Row A Column 1 Column 2
Row B x(1) y(5)
Row C x(2) y(10)
Row D x(3) z(15)


I would appreciate any pointers or help the community could send my way. Thanks!!!!

-New College Hire, John in the Workforce. :D