Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
When creating differnet types of graphs/charts, is there a way to choose how the items are sorted in their presentation?
For example, with a donut chart, I am trying to show the count of each "n" as a proportion of the overall count in that column. But it keeps sorting by ascending counts, IE. if the highest count is "h" at 47 then that comes first, when i'd like "a" to come first even if it isn't the highest count value.
Solved! Go to Solution.
You can change some sorting behavior by clicking on the ellipsis at the upper right of the chart/visual. If that isn't enough, you'll need to use the Sort By Column feature in Power BI. Please see this article
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@BC00 , Have tried changing the sort order using the three dots.
You can change some sorting behavior by clicking on the ellipsis at the upper right of the chart/visual. If that isn't enough, you'll need to use the Sort By Column feature in Power BI. Please see this article
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Great! Thanks, did not realize that was an option. Exactly what I was thinking.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |