Forum Discussion
Does Power BI support sorting established in a data model?
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.
Are you certain that you are using Desktop and not Designer? I am using Desktop and went through the following excercise:
Imported the following data:
Name,Quarter,QuarterSort
Thing1,Q1 2015,2015Q1
Thing2,Q2 2015,2015Q2
Thing3,Q3 2015,2015Q3
Thing4,Q4 2015,2015Q4
Thing5,Q1 2014,2014Q1
Thing6,Q2 2014,2014Q2
Thing7,Q3 2014,2014Q3
Thing8,Q4 2014,2014Q4
Note that there is NO visual indicator of sorting here but I clicked the "Quarter" column heading and it sorts this way (perhaps this is the issue??)
Went back to data model, selected the Quarter column and changed Sort by column to QuarterSort and then went back to my report and it looked like this (without me touching anything):
yes, sorting works for me too... If you explore your Tabular model and not import from in it should work.
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.