Problems with SSRS Graph (data froma SSAS cube)

Question

Hello,

I have the following mdx from an SSAS cube:

SELECT NON EMPTY { [Measures].[Average Price] } ON COLUMNS, NON EMPTY { ([Dim Date].[Date Hierarchy -Month-].[Month].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Price Observer DM] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

When i add to my report a matrix in tabular form i get the correct result: In the one column the date (month - year) ordered Dec 2009-Dec-2011 by date. When i create a graph (line) i put the date in the x axis but the months are not orderd by date but alphabetically. How can i have the x axis ordered by date as in the tabular form?

Thanks in advance,

Andreas

Answer 1

Hi There

This is simple enough please go to x-axis series properties as shown in the attached figure and sort according to your need.

I hope this will help.

Many thanks

Syed Qazafi

Answer 2

Just check if you have the Month Group Sorted by alphabetically...remove that

---

Rakesh M J | MCTS,MCITP ( SQL SERVER 2008 )

Dont forget to mark it as Answered if found useful | myspeakonbi