Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Filters in reports help

Hello Community. Quick question. I have a Line chart that looks like this:

pregunta.jpg

 

But as you can see, it looks too crowded and it's difficult to read. So I was wondering if there's a way I can filter those items on the legend. Like with the years, when I click a particular year, the whole chart changes. Can I have a filter with the names of the items on the legend, so when I click on one of those items the whole chart changes? Like this

 

pregunta2.jpg 

 

Or this:

 

pregunta3.jpg

 

Each of the items on the legend has its own table

Thanks in advance!

2 REPLIES 2
Greg_Deckler
Super User
Super User

You should, is the item in the legend a column? You can just add a slicer for it. Alternatively, you can actually click the legend items to filter the report.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks for the quick response. The items in the legend are not in a column, each item in the legend has its own table with its own data. I attach an image of the whole viewpregunta4.jpg

I tried clicking the legend items but it doesn't help much with the reading of the chart. Still looks way too crowded:

 

pregunta5.jpg

 

Thanks in advance.

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!

December 2024

A Year in Review - December 2024

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