Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Filter by legend

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!  

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

Syndicated - Outbound

@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. 

basic filtering.JPG


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.

View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

Syndicated - Outbound

@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!!



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

V-pazhen-msft
Community Support
Community Support

Syndicated - Outbound

@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. 

basic filtering.JPG


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
Super User
Super User

Syndicated - Outbound

@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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)