Forum Discussion
Modify the legend order
- 10 years ago
You have to create Measures for each type of Status
Then place each Measure in the Values area in the order you wish
I responded to a similar question but for a pie chart today - it works exactly the same way with a bar chart
http://community.powerbi.com/t5/Desktop/Rearrange-Pies-in-Pie-Chart/m-p/25218#U25218
I came across another way to do this that doesn't require the creation of new measures. Here are the steps:
1) Select your visual.
2) In the Legend pane, select the arrow next to the field that you want to reorder.
3) Select New Group.
4) Create a name for your group (Power BI will populate one by default).
5) Use the group dialogue to create a separate group for each attribute value that you want to appear separately in the visual. You can group attribute values or keep them separate by creating a group for each one. There's also a handy "Include Other group" option that groups any remaining attribute values into an "Other" category if you don't need them broken out.
6) Since Power BI orders the legend alphabetically, if you rename the groups and place a number in front of each one indicating the order in which you want it to appear ("1)" or "1-" or "1:" for example), Power BI will display the groups in ascending order based on the leading digit.
Power BI also allows you to reuse the grouping you created in other visuals. It's a really handy way to reorder the attributes if you don't mind there being a number in front of each item in your legend.
Stephan's solution looks perfect to my situation, but I don't see the "New group" option if if select the arrow. I only see the options "Delete field", "Change name" and "Show items whithout data". Has the "New group" option been deleted or am I looking at the wrong place?
- Chamudi1 year agoRegular Visitor
You need to add the field you need to create groups from to Legend field and then start creating groups.
One more thing I was struggiling: to rename the newly created groups, double click on the group name!!!