Slicer first and then a stack chart with multiple variables

[Gems]

Hi! I'm stuck!  I need help in doing this:

First, I need to create a Slicer with the colours variable, so you can choose Red, Purple, etc. Once you have selected the colour, the stack chart should represent the variables Cars, Bikes, Motorbikes and Truck on the Y axis and the staked variables should be A and B.

So I can't reach the way you may organise the dataset in order to have the slicer first and then using the Stack Chart the way I mentioned.

This is the graph I need when you pick Red in the Slicer, and so on. (The values on the graph aren't correct, is just an example of what I need).

Thank you soooo much!!! 🙂

[rsbin · Accepted solution]

@Gems,

As you mentioned, first step is to get your data into a proper table.  For this I suggest:

ColourSlicer	Vehicle	Category	Value
Red	Cars	A	19.0
Red	Cars	B	83.6

Once the table is set up in this manner, the Slicer Visual and Stacked Bar chart will come naturally.

Hope this gets you going.

Regards,

[Gems]

Thank you so much! I was really stuck with this. 

I've learned so much with your answer and the problem is solved.

Thank you so much!

[rsbin]

@Gems ,

Glad I could help. 

Just keep thinking in terms of dimension and fact data tables, and things become much easier to visualize.

Good Luck and Best Regards,