Forum Discussion
amalrio
Helper V
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 bel...
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
amitchandak
Super User
Super Useramalrio , 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