Sort the SMall multiples with rank column withoust showing its value on visual

[Anonymous]

Hi Folks,

I am working on a requirement where I need to use a text calculated column as a small multiple axis . I have a rank calculated column too. Now I want to  sort the visual by Rank column as small multiple axis but also want to keep the text on small multiple axis.I want to show few specific values from the text column first and then remaining ones (because of this reason only i created the rank column so that I could sort it in number format not the alphabetical format).I achieved this visual so far(sorted by rank):

I want keep the sorting by rank but dont want to show its value on the visual.Example Search and Item should stay sorted as they are but it shouldnt be displayed as 1.search , it should rather be displayed as just Search.

Please advise if there is a way this can achieved Or If there is a way that I can just keep the text column  but sort it in whole number format.

[amitchandak]

@Anonymous , Have tried marking the rank as sort column

Text Column 1 = [Text Column]

Text Rank = rankx(table, [Text Column],,asc,dense)

Then Mark Text Rank as Sort column of Text Column 1 and use that in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

Thanks @amitchandak  but it still sorts it in alphabetical order.I have calculated column which of text type and then i created the rank calculated col the way you mentioned above. I applied sort by the rank on the text column but  rank column still shows the value in alphabetical order.Since we are using a column of text type in the rank code you mentioned, it has to get sorted in alphabetical order, right?