Forum Discussion
Sort By Column grayed out
Primary tableI 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.
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.
4 Replies
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.
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.
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.
