Reorder Series Items in Column Column (Report Builder 3.0)

I have a chart in Report Builder 3.0 that uses stacked columns to display data. Each item in a series group has its own block in the header and footer column. Since I have a large number of items in a series group, I want to rearrange the order in which these boxes are displayed so that it is easier for users to determine which parts are more important. Can anyone help me to make a stack of a column change the order in which its elements are "stacked?" Thank.

+3


source to share


2 answers


Click on the columns of the chart. a small section will appear on the right side with the "Values", "Category Group" and "Series Group" sections. you can right click on a group of categories or groups, go to the Sort tab and sort the data as you see fit.



+4


source


Try setting up a custom expression for your Series group?



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

+1


source







All Articles