Forum Discussion
WishAskedSooner
6 months agoContinued Contributor
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...
- 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.
krishnakanth240
6 months agoSuper User
Can you try this adding a measure. From the settings we dont have the option to sort based on Total of two individual measures.