Forum Discussion
Matrix order columns - SSAS Azure DWH
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.
Best Regards,
Dale
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".
Best Regards,
Dale
Hi v-jiascu-msft,
Yes, it is indeed a live connection. Unfortunatly I have to search for a solution in the SSAS model. One solution I now can think of is changing the column values to: a. Jan 18, b. Feb 18, c. Mar 18 etc.
It would however be a nice feature for the Powerbi Matrix also to sort on the columns with a live connection. I mean it is possible to sort the rows, so why not the columns.
Best regards,
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.
Best Regards,
DaleHi 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.