Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Continued Contributor
6 months ago
Solved

Stacked Bar Chart Sort

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 m...
Need Help
  • QuentinGa's avatar
    QuentinGa
    6 months ago

    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.

danextian's avatar
danextian
Super User
6 months ago

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.