Max function changes when different slicer buttons are selected

Copper Contributor

Good evening!

I have a Pivot Chart controlled by a slicers, which has three buttons (categories). When I click one of the slicer buttons I would like to see a MAX value (as a bar/column) appear on the chart, which changes when I select a different slicer button. Currently, the MAX value that is displayed is for the whole dataset isn't changing when I select a different slicer button.

 

Is there a workaround for this?! 

 

Thanks

Nicola

0 Replies