Skip to main content

    Power BI

    Needs Votes

    Sorting from data source for SSAS Dimension Hierarchies calculated coulmns

    Vote (4) Share
    's profile image

    on 24 May 2016 12:24:13

    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.

    Comments (2)
    's profile image Profile Picture

    SpinyNorman on 05 Jul 2020 23:00:38

    RE: Sorting from data source for SSAS Dimension Hierarchies calculated coulmns

    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.

    's profile image Profile Picture

    SpinyNorman on 05 Jul 2020 23:00:38

    RE: Sorting from data source for SSAS Dimension Hierarchies calculated coulmns

    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.