Forum Discussion
Solved
Using a slicer on a stacked column chart
I have a stacked column chart which I've manipulated to look like a waterfall chart, to show how sales go from A to B over a period of time. The x axis is the passage of time and segments in each col...
Hi OllieHiggins ,
Please refers to the following steps.
Create corresponding measures for each channel and use them to create field parameters and a slicer.
Channel1 = SUM(Sheet1[Channel 1])Channel2 = SUM(Sheet1[Channel 2])Channel3 = SUM(Sheet1[Channel 3])Place the field parameter field in the Y-axis, replacing the 'Channel1', 'Channel2', and 'Channel3' fields.
The final result is as follows.
Please see the attached pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi OllieHiggins
Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. This will make it easier for us to figure out what you're trying to achieve.