Filter by legend

[Anonymous]

Hi,

is there a way to use a chart's legend as a filter for the chart? It seems the only way to filter a visual is to use another visual (as you can edit the interactions between visuals, whether it filters, highlights or does nothing). But there is no option it seems to edit how a visual interacts with itself. So clicking on a legend highlights data on the chart, and there doesn't seem to be a way to change this to filtering. Any help much appreciated!  

[parry2k]

@Anonymous Good point but this is the first time I have even seen such a request, it doesn't mean more users are looking for such a solution. I would highly recommend posting this as an idea on the ideas forum and promoting it so that people can upvote on this to have the attention of the product development team. Cheers!!

[V-pazhen-msft · Accepted solution]

@Anonymous 
You can not change the click legend active from highlight to filtering, that would inconvenient when comparing the values in legend column. For filtering, you could just used the basic filtering type in the filter panel on the legend column. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous yes clicking of legend will not filter the visual itself, and I don't think that is even a good idea. Not sure what problem you are trying to solve here.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Here is a possible reason to filter by legend.  I have a map that displays Work Order locations at an airport on a map visualization.  I want to use the colored type of Work Order legend (same colors as bubble GPS locations on the chart).  Right now, clicking on the legend only results in highlighting the selected legend in bubbles (very difficult to see this selection)- I want to "filter" out other legend displayed bubbles using the selected legend.  Using the legend removes my need to add a slicer to accomplish this filtering.  Why have an additional slicer (that takes up visualization space I can use for the map) when I can just select the legend and remove (filter) all other bubbles on my GPS map? Thanks for any ideas on how to use the legend as a filter.