Forum Discussion
Gazzer
Resolver II
Resolver IISort using the Sort by Column Button not Working
I am trying to sort a simple table of data using the Sort by Column button on the Modeling ribbon (and the one on the Modeling tab). I can never get it to work. I have followed the steps from the dir...
MattAllington
Community Champion
Community ChampionThe target column ( column you want to sort) must have the identical grainularity of the sort column, and there must be a 1 to 1 match between the columns. So if you have a month name column, there are 12 unique values. The sort column must also have 12 values. If 1 = Jan then 1 must always = Jan. The 1:1 match must never chabge
GazzerThanks for the reply - none of what you describe is mentioned in the documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/#sort-using-the-sort-by-column-button
I will try what you have described, but at the moment it feels like it will be impractical to implement (I accept I could be wrong)