Habib on 22 Jun 2016 20:19:48
How about adding option to make a metric/measure as selector. Actually, it will be only metric name which will serve the purpose of selector and you can give user option to switch to different measures by looking at same graph.
One example is Sales $ and Sales Unit by months. In current options, if you want to place both measures in a dashboard you either need to add two graphs, one for each. Or you can add both measures in same graph by using line and bar chart. Having measure name as selector, you will have option to change your measure on run time on same graph to view the result. Like if you have radio button option for Sales $ and Sales U, and you have bar chat, you can select any of the measure to be shown in graph. This will give a more flexibility to developers and users.
- Comments (3)
RE: Measures/Metrics Name as Selector
This would be very helpfull indeed, especially in you have a large model, it is a lot of work to add all of them to a single measure, and keep track of two places for the format (both the measure itself and a SWITCH measure! They added grouping to PBI and that is also quite easy to do, but still valuable to add it directly without code to make it much more accessible for non-tech users!
RE: Measures/Metrics Name as Selector
Thanks @Megan for sharing the link. Problem with this approach is that we will have to rebuild entire set of measure again.
RE: Measures/Metrics Name as Selector
This is a good idea that can already be accomplished with DAX and a disconnected table. This blog post is about Power Pivot, but you can get the general idea: http://sqljason.com/2012/11/measure-selection-using-slicers-in.html