Forum Discussion

Yme's avatar
Yme
Frequent Visitor
7 years ago
Solved

Matrix order columns - SSAS Azure DWH

Dear readers,   I have a small problem I cannot figure out. I have a matrix where I want the columns sorted based on a invisible datetime column.   The rows are years: and are sorted. Good! The ...
Need Help
Tips and Tricks
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Yme,

     

    Since it's a live connection, almost all are defined in the SSAS Server. Maybe you can change it in the SSAS model. Please refer to the snapshot below. It could help.

    Matrix-order-columns-SSAS-Azure-DWH2

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Yme,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Yme's avatar
Yme
Frequent Visitor
7 years ago

Hi v-jiascu-msft,

 

Yes, done. After some changes to the data model I used your solution and it works! The months are now sorted in the columns.

Thank you!


Best regards