Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a line chart visual that I need to sort via Year and Month so it should be Sept 2020, Oct 2020, Nov 2020, Dec 2020, Jan 2021, Feb 2021 etc
I created a new table to abbreviate the Month names (from Septembre to Sep) and have joined this to my date table.
I am sorting by Year Month Abbrev Ascending
https://drive.google.com/file/d/1lsGVhogTsHzMsmzFqUpMk0YFTBJYFpUT/view?usp=drivesdk
Solved! Go to Solution.
I've added a month number then used the Column sort to define sort order and this worked
I've added a month number then used the Column sort to define sort order and this worked
I have a column for month number but it only goes to 12 where I think I need it to go to 24?
I tried a few methods to correct such as "Month Number", (YEAR([Date])-YEAR(MIN([Date]))) * 24 + MONTH([Date]) but this doesn't work.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
22 | |
17 | |
10 | |
8 | |
8 |
User | Count |
---|---|
37 | |
28 | |
18 | |
17 | |
14 |