Forum Discussion

Frequent Visitor

9 years ago

Sort by column based on another column for SSAS Tabular Source

Hi, I want to sort the month name based on month number using SSAS tabular source in power bi. I can see that sort by option in modeling tab is disabled. Is there any other way to sort the column or...

Anonymous

Not applicable

9 years ago

Hi ravindrajal,

If you use import mode, it is possible to sort by column based on another column.

If you use live mode, it is impossible to use this feature.

Regards,

Xiaoxin Sheng

Anonymous
Not applicable
8 years ago
I wonder why they don't allow it. It's a sort order we are enforcing on the viz or report. It's not going to harm the underlying schema. I feel with these many restrictions when using SSAS makes people think that it is not self-service BI any more. Really like to know what is the rationale behind MS diableing most of the features in PBI with SSAS. ex. no data or data model view, no formatting, no calculated tables. MS are you listening ???
- Anonymous
  Not applicable
  3 years ago
  *checks watch* No, they are not listening
nandhinielango
Frequent Visitor
8 years ago
Hi,

Is there any method to implement it in SSAS Live Connection
- ravindrajal
  Frequent Visitor
  8 years ago
  Hi I did it by sorting the columns in ssas data model and then used the columns in power bi. There is no direct sorting available in power bi for ssas data models
  - octoni
    Frequent Visitor
    8 years ago
    
    Hi ,
    
    I face similar isu, and it seems it doesn't work when displaying SSAS data in chart format. I can't sort the data by another column which is not choosed in axis field. The column that I want to sort is a date string, and there is a date key column.
    really appreciate any thought to solve this.
    
    Cheers,
    octoni