Forum Discussion
Helper Vsorting a stacked area chart by value
Hi helpful people,
how do I sort stacked area graph by x axis as well as value plotted, for instance I want below graphs blue coluours section in the bottom of the graph(NA Plant data in the below data table) as B plant show in the bottom of the graph (I assume it sort by the ledgend) I want to sort by the value.
Below is my data set.
what I want in the Graph is NA Plant bottom of the graph( in the above graph it is in the Blue section.) years has to be from 2021 to 2025 (incrreasing frequency)
thanks for your help in advance.
amalrio , I am assuming you are taking of legends.
You need to create columns like
Plant1 =[Plant]
Plant1 sort = switch(true(),
[Plant] = "NA",100,
[Plant] = "Plant",1,
// add others
1000
)
and sort plant 1 on plant 1 sort and use plant 1
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
1 Reply
- amitchandak
Super User
amalrio , I am assuming you are taking of legends.
You need to create columns like
Plant1 =[Plant]
Plant1 sort = switch(true(),
[Plant] = "NA",100,
[Plant] = "Plant",1,
// add others
1000
)
and sort plant 1 on plant 1 sort and use plant 1
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column