CODEWITHSUNDEEP
reporting-servicesreportbuilder3.0
Graham Carling
Graham Carling

Reputation: 563

Change the order of the series items in a stacked column (Report Builder 3.0)

I have a chart in Report Builder 3.0 that uses stacked columns to display data. Each item in the series group has its own block on the stacked column. Because I have a large number of elements in the series group I want to change the order that these blocks display in so it's easier for users to tell which parts are more important. Can anyone help me make a stacked column change the order in which its elements are "stacked?" Thanks.

Upvotes: 3

Views: 6688

Answers (2)

Hamza
Hamza

Reputation: 49

Click on the Columns of chart. a small section will appear at right side having sections of "Values", "Category Group" and "Series Group". you can right-click on the Category Group or Series Group, go to Sorting tab, and sort the data as you wish.

Upvotes: 5

glh
glh

Reputation: 4972

Try setting up a custom expression for your "Series Group"?

See Sort Data in a Data Region (Report Builder and SSRS).

Upvotes: 1

Related Questions