Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
LW66
New Member

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 use as a filter, but I can't work out how to get them into a clean ascending order (1, 2, 3, 4). Hopefully there's a nice easy fix?!

 

LW66_0-1704450182811.png

 

2 ACCEPTED SOLUTIONS
mh2587
Super User
Super User

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


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



View solution in original post

3 REPLIES 3
mh2587
Super User
Super User

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


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



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.

LW66_0-1704452135049.png

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.