cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Sort by column not available

Hi,

 

I have 2 columns for month, one displays the month name and the other the month number. This is to allow me to sort the month names correctly (e.g. Jan, Feb,.....Dec) by sorting the month name column by the month number column.

 

Usually this is done by using the "sort by column" tool but it seems to not be avaialble for any of my columns, the option is greyed out in PBI. I also can't create any new columns either.

 

I should note that my data comes directly from Alteryx via the Power BI service and appears under "my workspace", which I assume is the reason why it doesn't work. Does anyone have any ideas how I can sort these months? 

 

Thank you!

 

afk

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Sort by column not available

Sounds like you are in the Service and not the Desktop? Perhaps try putting your month number in the visual and selecting the ellipses and sorting by it?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper V
Helper V

Re: Sort by column not available

Hi @Greg_Deckler,

 

Thanks for your quick reply.

 

I am actually using the Desktop version. I've tried that method before, but in the sort by option under the elipse, it doesnt seem to show the trading month number column.

 

I retrieve my data from the "Power BI Datasets" option under "Get Data".

 

 

afk

Highlighted
Helper V
Helper V

Re: Sort by column not available

Hi,

 

Is anyone able to help with this? The option to sort by column is not available for me and my months are being sorted alphabetically, which is incorrect.

 

Thank you!

 

 

afk

Highlighted
Community Support
Community Support

Re: Sort by column not available

Hi @bo_afk ,

If you mean live connection to power bi service, current you can't do customize with data model fields on this mode.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors