Forum Discussion
Sort graph bar by total not by category
Hello Fellas,
i want to solve my problem of sorting by the total in my graph bar.
Thanks in advance.
Lyes
Hi Anonymous -can you pls follow the below steps:
Select the Bar Chart in your report.
Click on the ellipsis (...) in the top-right corner of the visual>>Go to "Sort axis" → Select the Measure (Total Value)>>Choose "Sort Descending" to sort from highest to lowest or "Sort Ascending" for the opposite order.
Then, go to "Sort by Column" and choose TotalValue to sort by total.
3 Replies
- rajendraongole1
Super User
Hi Anonymous -can you pls follow the below steps:
Select the Bar Chart in your report.
Click on the ellipsis (...) in the top-right corner of the visual>>Go to "Sort axis" → Select the Measure (Total Value)>>Choose "Sort Descending" to sort from highest to lowest or "Sort Ascending" for the opposite order.
Then, go to "Sort by Column" and choose TotalValue to sort by total.
Hi rajendraongole1 , i dont find : ""Sort by Column" and choose TotalValue to sort by total." thanks in advance
v-karpurapudCommunity Support
Hi Anonymous
Thank you for reaching out to the Microsoft Fabric Community Forum.
To sort the bar graph by total, please follow these steps:- Create a DAX measure to calculate the total sum for each category and select the Stacked Bar Chart in Power BI.
- Add the newly created measure to the tool tip in visualiaztion pane. Once Total_Value is part of the visual, go to Sort axis, select Total_Value, and choose Sort Descending to display the highest total values first.
Please refer the below snapshots for detailed understanding:
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You.