How to order by MonthID in PowerView extension for sharepoint

Hi there,

Is there any way to sort the Months in the natural order in PowerView extn of Sharepoint.

I am using in the x axis of a chat, the Months member of a calendar dimension, and it is always displayed in alphabetical order. 

I know it can work in excel addin of powerview, but how to make it work on sharepoint addin??

Thanks and best regards,

Deeraj

January 9th, 2014 11:18am

Hi,

As this question is more relate to SQL Server Reporting Services, I suggest you post it to SQL Server Reporting Services, Power View Forum, you will get more help and confirm answers from there.
http://social.technet.microsoft.com/Forums/en-US/home?forum=sqlreportingservices

Best regards

Free Windows Admin Tool Kit Click here and download it now
January 10th, 2014 4:42am

Hi Deeraj

I understand that it is quite late answer, but still wanted to answer so that it might help.

To sort the Months members in the natural, please set the 'OrderBy' property of the 'Month' attribute in the dimension to 'KEY'. It works.

February 24th, 2014 4:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics