Use slicers to select the facts in a pivot chart
n one of my previous posts link - I described how you can create a dynamic pivot chart in Excel 2013 - but it did require VBA to change the fact.
But inspired by Rob Collie - link - @powerpivotpro - and several readings about the DAX SWITCH function - I decided to see if I could use slicers to create a dynamic chart using Slicers.
Read more...