This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 33 | |
| 31 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 55 | |
| 31 | |
| 24 | |
| 23 |