Report Portal

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...

Tags: excel, dax, slicer, tabular

 

2007-2015 VidasSoft Systems Inc.