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
magnificentnile
Regular Visitor

line chart with selectable legend

Is it possible to create a multi column legend that filters the lines that appear in a line chart?  The following is a mock-up of what I have in mind. 

 

The data is a table with 50 series containing monthly data collected from the last 5 years. 

 

If I create a line chart using the default line chart, it is not possible to modify the legend styling. Furthermore, if I try to use another widget to create a filter, the filter allows me to use the rows as filter items not the columns. 

 

Is there a way to do this? For example create a second table of only the series names and somehow key the legend table to the main table fields? 

 

LIIP.jpg

1 ACCEPTED SOLUTION

We have imported  the data in "long" format rather than "wide" format, so we can use the categories as a "filter" on the chart. 

 

LIIP data.jpgThanks againLIIP v4.jpg

View solution in original post

2 REPLIES 2
v-xjiin-msft
Solution Sage
Solution Sage

@magnificentnile

 

As I know, in current Power BI Desktop. It is not supported to add multiple legends to a chart.

 

In your scenario, do your 50 series have some kind of hierarchy relations? If so, I would suggest you to try the Drill Down feature.

 

Also, it will be more helpful if you can share us some sample data. So that we can make some proper tests.

 

Thanks,
Xi Jin.

We have imported  the data in "long" format rather than "wide" format, so we can use the categories as a "filter" on the chart. 

 

LIIP data.jpgThanks againLIIP v4.jpg

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors