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?
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.
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...)!