Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am struggling with how to sort the slilcer the way I need:
I have a table like this:
Number Month
1 Jan
2 Feb.
3 March
etc...
The slicer only allows sorting alphabetically, but I want the months in the Slicere to be sorted by their Number. I know now the Slicer suprisingly doesn't allow to sort by another column in the table. So what are my options?
I followed this recommerndation https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/ and sorted by the Number in the QueryEditor, but it has no effect on how the Months are displayed. Am I doing somehtign wrong, or is it Slicer's specific?
Thanks a lot!
Solved! Go to Solution.
@sanoraya - To order your months by a number range I go to the data tab in Power BI desktop:
In the ribbon you will see the Sort By Column button. Select the column you are interested in first (in my picture it would be Months), then click the Sort By Columns button.
Now you need to have a column which lists the months in the numeric order you want. For example, January will always show up as 1. In the sort by column button you will then need to click the appropriate column containing the month numbers.
This will then sort your slicer the way you want.
Thanks,
Giles
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |