Base and Compare Values for multiple slicers to be shown in single Stacked Bar chart

[vith]

Hi, I have 3 slicers for Base value, and other 3 slicers for compare value, so total 6 slicers. In the base slicers, all value is shown. and In compare set of slicers, user can give value for all 3 slicers. This comparison of base and compare is to be shown in stacked bar chart. Can someone please help me with that?

[Anonymous · Accepted solution]

Hi @vith ,

I create two simple tables as you mentioned.

Then I create two slicers and a Stacked column chart.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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