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.
This one is an oldie but a goodie. I've not found a solution to something that seems like it should be straightforward. Lots of posts on how to do this but they are not working for me.
I have table that has some dates. It's not a Calendar table, just some dates.
I have a SortOrder column that is sorted in the table and in the visualization.
February 2024 should appear first, then January 2024, etc. The dates go back to July 2023. I always end up with the axis sorted by Month Name.
What am I doing wrong?
Solved! Go to Solution.
Hello @ICW1972 ,
if you want to only sort the months in the slicer , then you click on the month column and sort by month number
Proud to be a Super User! | |
Solution is here:
https://community.fabric.microsoft.com/t5/Desktop/Name-of-Month-in-Slicer-is-not-in-right-order/td-p...
You have to click on the table column and select a different sort column. Very confusing for me personally.
Solution is here:
https://community.fabric.microsoft.com/t5/Desktop/Name-of-Month-in-Slicer-is-not-in-right-order/td-p...
You have to click on the table column and select a different sort column. Very confusing for me personally.
Hello @ICW1972 ,
if you want to only sort the months in the slicer , then you click on the month column and sort by month number
Proud to be a Super User! | |
Not really. If I have two July months (2023, 2024) that doesn't work. That's why there is a SortOrder column to provide distinct values.
I tried your suggestion anyway and it doesn't sort.
Thank you for replying though!
@ICW1972 ,
So you need to have a year/month column as the following:
year/month = format('YourTablename'[dateColumn],"mmm YYYY")
year/month sort = format('YourTablename'[dateColumn],"mmYYYY")
and sort the year/ month column by the year/mont sort.
Proud to be a Super User! | |
Whether I sort by a distinct number or your suggestion is immaterial. The SortOrder should be observed now without changing anything and it isn't.
I tried a simple case of manually creating a table with a few rows and it still cannot sort by the SortOrder column even if it's hardcoded (1, 2, 3, 4). It's one of those things in Power BI that ought to be straightforward.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |