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 th...
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.
