Displaying the selected line in a graph

[Anonymous]

Hello,

When I select an option from the legend of a graph, I want to display only the selected line in the graph and all other lines should be invisible.

Can anyone help me with this, please?

[Anonymous]

Hello @PaulusD,

I've tried to add the legend values to a slicer as you suggested, but I'm unable to add them to the slicer may be because they are measure values.

Is there any other way to acheive this?

[PaulusD]

Not sure you can place measure values in a slicer... If the result is numerical you could try something like this:

Power BI - Filter by a Measure in a Slicer - YouTube

Otherwise try making a calculated column instead of a measure and use the column in a slicer. That way you can also group the values if you want.

[Anonymous]

@PaulusD 

I want ot get the values as a list to choose from not as group of values, is this possible to do?

[PaulusD]

If you calculate the values in a calculated column instead of a measure, it should work just fine  :).

[Anonymous]

Thanks I'll try this

[PaulusD · Accepted solution]

Add the values that you have in the legend to a slicer next to the graph. by default a slicer will filter out the rest of the values 😊.