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,
Can any one please help me on below issue.
How to sort MonthName from January to December in Slicer.
Thanks in advance.
Solved! Go to Solution.
Hi,
You can a calculated column to get month numbers
Then sort the Month Name column by Month Number column
Month_Number =
SWITCH (
[MONTH_Name],
"August", 08,
"December", 12,
"July", 07,
"November", 11,
"October", 10,
"September", 09,
"April", 04,
"February", 02,
"January", 01,
"March", 03,
"May", 05,
"June", 06
)
Check this post as well
http://www.excelnaccess.com/custom-sorting-in-power-bi/
Hi,
You can a calculated column to get month numbers
Then sort the Month Name column by Month Number column
Month_Number =
SWITCH (
[MONTH_Name],
"August", 08,
"December", 12,
"July", 07,
"November", 11,
"October", 10,
"September", 09,
"April", 04,
"February", 02,
"January", 01,
"March", 03,
"May", 05,
"June", 06
)
Check this post as well
http://www.excelnaccess.com/custom-sorting-in-power-bi/
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |