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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.