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.

QuentinGa's avatar
QuentinGa
Resolver I
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.