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 guys,
I have having difficulties sorting the month in my slicer.
Above is how it looks on the report.
Below is the data, i tried to change the data type to date but i get an error.
Please help!!!
Thanks,
Solved! Go to Solution.
Since you already have your month numbers, this will be very easy for you.
Select your Month column, then select the Modeling tab at the top ribbon, then use the "Sort by Column" option to select the MonthNo column. This is happening because a text field will sort itself alphabetically by default, but you can instruct that column to sort by the numbers in your MonthNo column.
EDIT:
Here's a quick demonstration:
Since you already have your month numbers, this will be very easy for you.
Select your Month column, then select the Modeling tab at the top ribbon, then use the "Sort by Column" option to select the MonthNo column. This is happening because a text field will sort itself alphabetically by default, but you can instruct that column to sort by the numbers in your MonthNo column.
EDIT:
Here's a quick demonstration:
Thank you for the quick respondse!
Ive made the changes and sort the column by MonthNo.
I then went back to the report and still unable to sort it to MonthNo.
I believe that the months have moved though....
That's odd. Are you 100% certain that you sorted that column by your "MonthNo" column?
I just verified that a slicer will also pick up on the Sort By option selected. Maybe you need to deselect the "Sort by..." option on the visual itself. Also, check to see what happens when you put them on a Table visual next to their MonthNo with nothing sorted.
Here is the table visual with the month without sorting.
Ive fixed the problem!
I didnt set a data type for the MonthNo column. Stupid me
Thank you for your help!!
I have set the slicer to sort by month no and i have set the month number to Whole number data type still the sorting does not happen. Can you guys help. TIA Swarna
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 |
---|---|
113 | |
100 | |
77 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |