Sorting a complex stacked bar chart in Power BI

[Anonymous]

Hi everyone,

How can I sort a stacked column chart in Power BI in descending order, bearing in mind that I want the data in each column to be stacked in ascending order?

Example. I have a table like this.

Column 1	Column 2
A	D
A	E
A	E
B	F
B	F
B	D
B	G
C	D
C	E
C	G
C	G
C	E
C	E
C	E

And graphically, I get this:

What I want is for the data in Column 2, regardless of its total value in the whole table, within each of the columns of the stacked chart to be sorted from most to least. In the example. That the first stacked column of the chart associated to the value C of Column 1, appears sorted 4 E, 2 G and 1 D (Column 2).

Could you help me?

Thank you very much in advance

[Anonymous]

I think that it is not possible to sort the Stacked chart as you want.