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.
Hi Stefan,
As per u i have created group but the problem is in the stacked column chart i am calculating the percentage of each category when compared to all categories.If i create a group as u mentioned i will get 100% for all the catgories.How to resolve this ?