Ranking Subjects

[agraffeo21]

I have ranked my countries by top 5, but they are sorted alphabetically... I would like them to be sorted by their respective rank.

Same for Month -- the months are alphabetically ordered, but I would like them to be ordered chronologically. Would like some advice on this please.

Thanks

.

[jahida]

Go to Modeling -> Sort By Column and pick the column you wish to sort by. Eg. Select the Country column, go to Modeling, Sort By Column, select Rank of countries by index.

This will require you making a numeric month column MonthNum = MONTH(Table[Month]) if you don't already have an equivalent.

Hope that helps!

[agraffeo21]

 @jahida thank you -- i think that is a start.

however the rankings are not static -- so if I change the date, the rank would also have to change. it does not sound like it would work if the column sorted them by month.

[jahida]

To clarify, is your rank currently a measure or a column? If a measure, the only way I am aware of to sort the table properly is sorting the visual manually ie. clicking on the header of the column you want to sort by.

EDIT: What do you mean by "if the column sorted them by month"? Which column (or both..?) are you worried about the method I mentioned above not working for?

[agraffeo21]

I have ranked my countries by top 5, but they are sorted alphabetically... I would like them to be sorted by their respective rank.

Same for Month -- the months are alphabetically ordered, but I would like them to be ordered chronologically. Would like some advice on this please.

Thanks

.