Dynamic dimension selection based on slicer
We should able to use same report to show measure by multiple dimension. Dimension should be selected based on slicer. If user select Product name from Slicer, Sales should be displayed based on Product name, If user select Country from slicer, Sales should be displayed based on Country
Jesse Crowley commented
There are workarounds using unpivoted table data, but generally there is no capability to use dynamic dimensions.
Kendall Lister commented
This, but for measures as well please! Would make switching currencies etc much simpler.
Rui Quintino commented
just brainstorming, having field parameters that work as field aliases, ex: defining a field what-if parameter alias called "Analyze Column" with a default field name, this appear as a draggable field for any visual, then be able to connect a slicer to this field and choose what model fields should be listed (type, table, wildcard,etc)
then when changing the slicer, the alias will change to that field, and all visuals update accordingly without touching the visual in any way
can be used for changing measures or fields, or even fields multi selection (ex: tables).