Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 49 | |
| 42 | |
| 25 | |
| 22 |
| User | Count |
|---|---|
| 143 | |
| 118 | |
| 56 | |
| 37 | |
| 31 |