Forum Discussion
Sorting a complex stacked bar chart in Power BI
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