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.

Read more...

Tags: dax, excel, slicer

 

2007-2015 VidasSoft Systems Inc.