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,

 

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

Yme's avatar
Yme
Frequent Visitor
7 years ago

Hi v-jiascu-msft,

 

I will take a look at your solution. See if I can this one to my datamodel.

I let you know if it worked!

 

Thanks in advance :)

 

Best regards.