PBI Report (connected to SSAS Tab) - how to order the columns of a matrix

[Anonymous]

Hi,

i would like to know how to, in a PBI report with data from SSAS Tabular, organize the order of the columns in a specific order.

I found a tutorial but it should only work with imported data, because when connected to Tabular we don't have access to PowerQuery and to the Modelling tab.

Or Is it supposed to, with a TextColumnA column with a Order By from an existing IndexColumnA in SSAS Tabular, automatically work in PBI reports?

Regards

[v-juanli-msft]

Hi @Anonymous

As tested with live connection, if you add the column in text and column in number type to a chart, you could sort the visual by the column added in this chart.

Best Regards

maggie

[Anonymous]

Hi,

But how can we order the columns of a Matrix visual? I think there is no option in the matrix visual for that...

And how can we get the data from that column previously from SSAS? 

Thanks