Forum Discussion

AlexDantin's avatar
AlexDantin
Helper I
11 years ago
Solved

Does Power BI support sorting established in a data model?

We have several date dimensions in our data model. Within them, we have hierarchies created to flow from date to month to quarter to year. To avoid the alpha sort on Month and Quarter, we have enforc...
  • AlexDantin's avatar
    AlexDantin
    11 years ago

    Ok - after reviewing the tabular model, the sort is set correctly (and I am exploring the model in Desktop)

     

    BUT -

     

    Power BI doesn't seem to recognize hierarchies established in a tabular model. The sort order was set to support the hierarchy, not the attribute on its own, so we have to change the sort key.

     

    Closing this topic.

     

andre's avatar
andre
Memorable Member
11 years ago

Power BI supports Sort By columns.  Click on the column you are trying to manage then click on Modeling->Sort By Column and pick the "hidden" sort column to enforce the desired sort order

  • AlexDantin's avatar
    AlexDantin
    Helper I
    11 years ago

    I'm directly connected to an SSAS tabular model...I don't see "modeling" as an option??

    • andre's avatar
      andre
      Memorable Member
      11 years ago

      AlexDantin if you are connecting to the tabular instance, then whoever built that instance for you can add that sort by logic to the date dimension in Visual Studio.  He/She will need to click on the column and then pick Sort By Column in Properties window on the right

      • AlexDantin's avatar
        AlexDantin
        Helper I
        11 years ago

        We've done that and Power BI is ignoring it - that's why my question was phrased as "established in a data model"