Column sorting in matrix visual - Sort By Column disabled

[Shishir]

Hello,

I am using Analysis Services - Live Connection for reporting.

I am using a matrix visual for reporting. We want to sort the column in reverse chronological manner however I dont see any option for sorting columns in matrix. Also Sort By Column option is disable.

Please advise if there is an option for column sorting .

Thanks 

[v-sihou-msft · Accepted solution]

@Shishir

For SSAS live connection, it's not supported to to any modeling. 

Using Analysis Services Tabular data in Power BI Desktop

Connect to SSAS Multidimensional Models in Power BI Desktop

Regards,