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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
sathyasbk
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.