Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?!
Solved! Go to Solution.
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!
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!
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |