Forum Discussion
Slicer first and then a stack chart with multiple variables
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!!! 🙂
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,
3 Replies
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,
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!
