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
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Yme,

 

Is it a live connection? If so, I'm afraid you have to adjust it in the SSAS model. If not, you could try these methods below.

1. If you add numbers like 1, 2, 3, you still need to change its type to "Whole Number" or other numeric types.

2. Add a numeric type column and use the function "Sort by Column".

Matrix-order-columns-SSAS-Azure-DWH

Best Regards,
Dale