Stacked Bar Chart Sort

[WishAskedSooner]

HI Experts!

I have a horizontal stacked bar chart with two measures in the X-Axis well. However, when I try to sort the Total of the stacked bars, there is only the option to sort the indivdual measures. This leads to really screwed up visual.

What am I missing? Is there a way to sort on the Total of the two measures?

TIA!

[danextian]

Hi @WishAskedSooner 

When multiple measures are used, sorting can only be applied to one measure at a time, not to all measures simultaneously. A common workaround is to use a disconnected table to materliaze the values of these measures using column values with a conditional formula, and then use that column as a legend. 

There are three measures in the example below, but only one is used in the visual - the one that's conditonally referencing them.

Please see the attached pbix.

[krishnakanth240]

Hi @WishAskedSooner 

Can you try this adding a measure. From the settings we dont have the option to sort based on Total of two individual measures.

[QuentinGa · Accepted solution]

Hi @WishAskedSooner,

It's not possible, it's a limitation of Power Bi.

You can only sort by individual measures.

You can try this:

- Create a measure that sums your two measures: Total = [Measure1] + [Measure2]
- Add this measure to the Tooltips field well of your visual.
- Then click the three dots on the chart, go to Sort axis and select your new Total measure.

Let me know if it works.

[WishAskedSooner]

@QuentinGa ,

That actually works! Kudos!