cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ricardo Member
Member

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

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

2 REPLIES 2
Community Support Team
Community Support Team

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

Hi @Ricardo

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.

11.png

12.png

 

Best Regards

maggie

Roco Frequent Visitor
Frequent Visitor

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

Hi @v-juanli-msft,

 

And if we don't want o add the number column to the table, is there another way to sort it by that number column?

 

Is there a way to sort it on SSAS or in the View of the tabular model so that we get it already sorted on Power BI?

 

I tried sorting in SSAS but it got the same result on Power BI (not sorted...)!

 

Thanks