Status:
Needs Votes
Sorting from data source for SSAS Dimension Hierarchies calculated coulmns
If we add calculated columns in a hierarchy in a SSAS dimension. Excel displays them as of data source order. but Power BI table / matrix sorts it Alphabetically.No option to remove sorting or get the sorting from source database. It is connected mode.
3 Comments
- Agreed, the sort order defined in the tabular model should be applied by default. It would be nice if PBI could allow some configuration beyond the model's default sort config.
- Actually, amendment to my earlier post: in the tabular model, the "Data Format" of the SSAS field needs to be correctly set. So for example if you're using a numerical Month to sort a field like MonthName, the Data Format of the Month field should be set to Whole Number and the Data Type field should be set to Whole Number. At least that worked for me.
- Status added:Needs Votes
