Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Number ordering

I feel like this must have been asked a million times but I can't seem to find an answer to resolve my issue, I have numbers out of order (1, 11, 12, 13, 14, 15) on a slicer visual which I wanted to ...
General Comment
Need Help
  • mh2587's avatar
    mh2587
    2 years ago

    Just duplicate the column and Name this Column "SortingColumn" in Power Query and replace 12a with 12.1 and 12b with 12.2 and 12c with 12.3 and Keep the data type in decimal then Close and Apply and Sort the oringinal Column with Sort By Column in Destop 
    Hope, Might help you this

mh2587's avatar
mh2587
Super User
2 years ago

Just duplicate the column and Name this Column "SortingColumn" in Power Query and replace 12a with 12.1 and 12b with 12.2 and 12c with 12.3 and Keep the data type in decimal then Close and Apply and Sort the oringinal Column with Sort By Column in Destop 
Hope, Might help you this

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Muhammad, thank you for such a speedy response! Where do I find the sort by column for my slicer? I can do a "sort axis" but this only shows the column used in the visual.