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
5 Comments
- This, but for measures as well please! Would make switching currencies etc much simpler.
- '+1 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).
- There are workarounds using unpivoted table data, but generally there is no capability to use dynamic dimensions.
- Adding similar visual with different dimensions consumes energy, time & lot of real state.It will give end user the flexibility to see same attributes against n number of dimension in single matrix/table.
- Status added:Needs Votes
