Forum Discussion

ABCD1234's avatar
ABCD1234
Regular Visitor
9 years ago
Solved

PowerBI legend ordering

Hi,    I am trying to create a multi series line chart using the following data. (Pic attached)  FEATURES LTL PRODUCT A PRODUCT B PRODUCT C PRODUCT D PRODUCT E UTL LENGTH -0.5 -0.2 ...
  • deldersveld's avatar
    9 years ago

    Especially if you plan to add new products over time, will be much easier to work with your data in a different format. If you unpivot the data and then load it, you would only have one Value column to add to the line chart, and as you add new products, they would simply become new Attributes.

     

     

    With the unpivoted data, you can setup your line chart as in this screenshot, and you can then click on the [...] in the top corner and sort by either the Features or Value.