Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am making a "lined and stacked column chart" in MS PBI Desktop.
I have the "Legend" turned on, and I want the color order in the Legend to match the color order in each part of the stacked column. This morning I found a PSPBI community post showing how to do this in the Modeling tab, by clicking on Sort by Column.
When I attempt the solution on the community post, my Sort by Column icon is greyed out.
How do I turn on Sort by Column?
Solved! Go to Solution.
@Anonymous,
Take a good look at Sort using the Sort by Column button.
For a pie chart you do not use the 'Sort by Column' button. You need to add the SORT field to Tooltips from Fields on the right.
Because it's a sort column you may need to set the field to Average (rather than Sum) or the order will be wrong. To do this click the dropdown to the right of the filed name once it's in the ToolTips box.
Then on the Pie chart use the drop down elipsis (...) top right to set that field as the sort order.
Also, if the pie seems to show the results in anti clockwise order you need to change your sort order from 1-10 to 10-1 as the Pie Chart shows the largest value first (as most people want to show the largest revenue first).
@Anonymous,
Take a good look at Sort using the Sort by Column button.
Hi, Sam
Nice work. That's exactly what I was looking for. I've noted that your answer came from the Power BI Desktop pane in the Power BI Documentation site. Will make a point to reference that in the future.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |