I have a bunch of slicers for a graph that work perfectly but want to find a way to have a slicer that controls the Y axis so I can toggle between two variables (Sales and volume) If I add sales and volume as a typical slicer I know it wont work because it will pull each individual value for sales and volume. Any thoughts on how to make this work so I can have a slicer that shows sales and volume so I can toggle back and forth?
Thanks!
Thanks!