Use slicers to select the facts in a pivot chart

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

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.


Tags: dax, excel, slicer


2007-2015 VidasSoft Systems Inc.