Forum Discussion
Rearrange 100% Stacked Bar Legend order when utilising negative values. (Survey Data)
Solution SupplierWithin transform data create a new numeric column to sit alongside your descriptions.
Description
| Description | Sort Order |
| Strongly Disagree | 1 |
| Disagree | 2 |
| Agree | 3 |
| Strongly Agree | 4 |
Once this is done, from within the data view pane set the Order By on Description to use the numeric value of Sort order.
Then within your visual, click the 3 dots (top right of visual) and set to sort by Description
Hey ajohnso2,
Thanks for your quick response; however, ordering by a numerical column isn't possible with measures. The measures are necessary to have the negative results to the left of the y-axis on a 100% graphic with survey responses.
- ajohnso2
If your descriptions are in their own dimension table (you can create this in power query if you dont have one). Join it to your fact data on description. You can then use the description from your new dimension table as the legend in your chart to make use of the sort order.
Are you able to share your pbix?