Forum Discussion

magnificentnile's avatar
magnificentnile
Regular Visitor
8 years ago
Solved

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 containi...
Need Help
  • magnificentnile's avatar
    magnificentnile
    8 years ago

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

     

    Thanks again

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

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.

magnificentnile's avatar
magnificentnile
Regular Visitor
8 years ago

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

 

Thanks again