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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |