Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sathyasbk
Employee
Employee

Sort By Column grayed out

Primary tablePrimary tableimage.pngI 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 20200.0493999323119915
P August 20200.720823042036147
P September 20200.642657299770031
P October 20200.120366950023601
P November 20200.0236852866880333

 

Sort order table:

 

FiscalMonthMonth order

P July 20201
P August 20202
P September 20203
P October 20204
P November 2020

5

 

Created a new column in the primary table to get the order:

 

FiscalMonthSales totalSort column

P July 20200.04939993231199151
P August 20200.7208230420361472
P September 20200.6426572997700313
P October 20200.1203669500236014
P November 20200.02368528668803335

 

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. 

 

 

1 ACCEPTED SOLUTION

@sathyasbk 

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.

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

4 REPLIES 4
sathyasbk
Employee
Employee

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. 

PaulDBrown
Community Champion
Community Champion

@sathyasbk 

 

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.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@PaulDBrown 

 

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. 

@sathyasbk 

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.

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.