(Design Studio 1.6) How to change the order of columns in a column infochart?

[former_member591771]

Hi all,

I have a column infochart with 2 data series, and I'm trying to change the order of the columns (e.g. if it is current - future sales now, I want future - current). I am a new user of BO Design Studio 1.6, coming from Excel (hence the "data series" term), where changing the order of the data series in a chart is a piece of cake - but I cannot find an easy solution in Design Studio. There's no relevant option in the "Additional Properties" and the only way of doing this is changing the dimension order in the query itself... but is this really the only way?

[former_member591771 · Accepted solution]

After experimenting more, it turns out that you can change the order mostly in crosstabs, not infocharts. Although sometimes it's possible for infocharts too. No clue why. But when it's not possible to edit the rows order in Design Studio (usually by editing the initial view of the datasource), then modifying the rows order in the query is the only way.

[former_member591771]

Thanks for the quick reply Rene, you're right that chart configuration has no effect (I can change the order in the chart configuration but this is not reflected in the report, when I run it on the BI platform). Editing the initial view of the DS was also my first approach, but I cannot change the key figures (measures / rows) in the initial view; I can only change the order in the Structure (columns), rearranging with a simple drag&drop. But this is not possible within measures, I can select a measure but I cannot move it around.

[former_member234401]

Try and rearange the KF in the datasource - it's not in the chart configuration. Drag and drop the KF in the edit initial view