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.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

Power BI Desktop does support a "Group By Column", (whoops, typo, meant "Sort By Column") so you could use that and have a sort by column like "2015Q1, 2015Q2". You could also change your column information to be 2015 Q1, 2015 Q2, etc and then it should sort the way you want.

  • AlexDantin's avatar
    AlexDantin
    Helper I
    11 years ago

    When we've already gone through the effort of designing the model based on the users desires for labels and formatting, renaming all the values doesn't seem like a reasonable alternative.

     

    And that still wouldn't solve the issue of displaying Monthly data over more than one year. Power BI recognizes Month name, but lumps all months across years. Not everything should be done as clustered bar/column charts.