Forum Discussion

OllieHiggins's avatar
OllieHiggins
Regular Visitor
1 year ago
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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

OllieHiggins's avatar
OllieHiggins
Regular Visitor
1 year ago

Brilliant, thank you!