Forum Discussion
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 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!
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.
4 Replies
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.
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.
Can you try this adding a measure. From the settings we dont have the option to sort based on Total of two individual measures.
