I receive requests from clients all the time like we want to have a dashboard where we will be able to dig into our data by different combination of filters.
About 5 years ago I posted here Dynamic Charts with macro which was adding and removing Dimensions and Expressions. Today I've changed my mind and have found alternative solution for this without macro. Take a look at attached doc for details.
