Forum Discussion
PowerBI legend ordering
- 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.
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.