sorting a stacked area chart by value

[amalrio]

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.

[amitchandak · Accepted solution]

@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