Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Primary table
I am trying to sort the month in a custom order. Below is the primary table and a table that I created for Sort order. Both are related.
Primary table:
FiscalMonthSales totalSort column
| P July 2020 | 0.0493999323119915 |
| P August 2020 | 0.720823042036147 |
| P September 2020 | 0.642657299770031 |
| P October 2020 | 0.120366950023601 |
| P November 2020 | 0.0236852866880333 |
Sort order table:
FiscalMonthMonth order
| P July 2020 | 1 |
| P August 2020 | 2 |
| P September 2020 | 3 |
| P October 2020 | 4 |
| P November 2020 | 5 |
Created a new column in the primary table to get the order:
FiscalMonthSales totalSort column
| P July 2020 | 0.0493999323119915 | 1 |
| P August 2020 | 0.720823042036147 | 2 |
| P September 2020 | 0.642657299770031 | 3 |
| P October 2020 | 0.120366950023601 | 4 |
| P November 2020 | 0.0236852866880333 | 5 |
Sort by column is grayed out when selecting the FiscalMonth column. As a matter of fact it is grayed across all PIBIX files and even on a brand new PBIX file with test data. Also, certain that I am clicking the column and no visuals are selected.
Solved! Go to Solution.
I believe the initial September realease had this problem. I dowloaded the last release (version posted) a few days ago. It works fine on this version.
Proud to be a Super User!
Paul on Linkedin.
The latest October version did not help. Rolled back to August and it works as expected. So trying a fresh install now. Thanks for your help.
Which Desktop version are you on?
The latest (Version: 2.85.985.0 64-bit (september de 2020) does not seem to have this problem.
Proud to be a Super User!
Paul on Linkedin.
I am running on the 2.86.542.0 64-bit (October 2020). I guess I was running the Sep version when I noticed this problem. first.
I believe the initial September realease had this problem. I dowloaded the last release (version posted) a few days ago. It works fine on this version.
Proud to be a Super User!
Paul on Linkedin.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 50 | |
| 46 | |
| 41 | |
| 39 |