Forum Discussion
Microsoft EmployeeAllow user to select values to be shown?
cmacdo wrote:
That actually looks like exactly what I need, but I'm going to need to play with it to get it to work for my needs and in PowerBI. The user is probably only going to want to be able to view one line at a time anyways, so one slicer should be enough. If you have any more detailed instructions that would be extremely helpful! Thanks so much!
To view one line at a time, you can create a table with one column valuing measures names. And filter the measures names in a slicer. In the line chart, put the a measure similar to below.
MeasureShown = IF ( HASONEVALUE ( 'MeasureNameTable'[MeasureName] ), ( SWITCH ( LASTNONBLANK ( 'MeasureNameTable'[MeasureName], "blank" ), "Measure1", [Measure1], [Measure2] ) ), [DefaultMeasure] )
Community Championadd a slicer for the attribute you want to control to your page. Then click on your new slicer and select "format\edit interations". from here you can conrol what objects your new slicer impacts. Just turn off the sliciing on every other visualisation.
cmacdoI think you misunderstood my question. I understand that a slicer allows you to filter for particular values for an attribute. However I want the user to be able to select only particular attributes/measures to be shown. For example, lets say I have a line chart that displays three measures over time, let's call these each A,B,C. I want the user to be able to deselect B so that the chart now only has two lines on it, one for A, and one for B. This has nothing to do with filtering on A or C, just allowing the user to remove the line for measure B from the chart altogether for their viewing purposes.
In my case, I have 20 or so of these measures I am trying to show, and it will be impossible for the user to see a specific value for 15 of them at a given date because the tooltip will only show the first 5. Hence why I want the user to be able to select which ones they would like to see at any given time. It might be impossible in the current set up, but if there is any custom visualization that allows this I would be all for trying that as well.
- MattAllington
You can't add or remove measures with a slicer. However if you have a fixed number of measures in a chart, you can swap "which" measures are displayed. Read this article I wrote some time ago.
http://www.powerpivotpro.com/2014/10/5-interactive-chart-techniques-come-together/
- cmacdo
That actually looks like exactly what I need, but I'm going to need to play with it to get it to work for my needs and in PowerBI. The user is probably only going to want to be able to view one line at a time anyways, so one slicer should be enough. If you have any more detailed instructions that would be extremely helpful! Thanks so much!