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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.