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.
Hello All I have Fiscal Month Coulumn and Fiscal Year column and I have created Calculated column as Fiscal Year & "-" Fiscal Month.
Now I need to sort like 2020-1,2020-2,2020-3,2020-4.... currently i have sorting like below. Kindly help
Solved! Go to Solution.
@harshagraj , You have to create FY month Sort and mark it as sort column
How to create FY month sort
Refer: https://youtu.be/w4U6Bi_fPek
@harshagraj , You have to create FY month Sort and mark it as sort column
How to create FY month sort
Refer: https://youtu.be/w4U6Bi_fPek
@harshagraj You will want to create a numeric column in Power Query that you can then associate with your column as a Sort By column.
Hi @harshagraj
If you have a date column, use that as a sort column for your Calculated Column.
Go to table view, click on the table, click on the Calculated Column, under Column Tools ribbon, click "Sort by column", and choose the date column.
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |