question

Sam123 avatar image
Sam123 asked

SSRS chart not ordering by desc?

Hello, Im trying to show the sales in this chart as descending, I already updated the group sort but it still not showing the top sales on the right descending to the left.

Im using Advantureworks database 2017

screenshot below

and the screenshot of the results below

ssrsssrs-2008reporting_servicesreport
11-22.jpg (81.1 KiB)
11.jpg (91.7 KiB)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

Doesn't your sort need to sort by SUM(TotalSales) I assume you want the chart to go from smallest total to largest total?

I bet your data has a very low individual value for "Central" and "Southwest" etc which brings them to the left even though their totals are higher than "Australia" etc

1 Like 1 ·

1 Answer

·
Jon Crawford avatar image
Jon Crawford answered

Agreed with Anthony. Also, 3D charts make it harder to determine values, not easier (which one is higher, UK or France?). Humans also perceive differences better in horizontal bars rather than vertical.

See Edward Tufte and Stephen Few for more ideas on data design

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.