Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |