Hi,
I am looking to make both a stacked and group chart in one. Attached is what my data looks like and an example chart of how I would like it to look.
I have about 30 Clients and I will be using a Filter Pane to only show one Client at a time that is why there the chart shown says Client A.
At the moment I am using the following expressions in my measures to get 2017 and 2018 side by side for the same Client.
sum({<Year={2017} >} [Stream 1] + [Stream 2] + [Stream 3])
sum({<Year={2018} >} [Stream 1] + [Stream 2] + [Stream 3])
Now, I would like to differentiate each stream (like a stacked chart) within each year to look like the example attached, because at the moment 2017 and 2018 are solid.
How do I go about this? Thanks!