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

yes, sorting works for me too... If you explore your Tabular model and not import from in it should work.

AlexDantin's avatar
AlexDantin
Helper I
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.