Power BI Unable to select sort columns

Viewed 9329

I am creating a Month table to be included in my Power Bi Dashboard as a Filter.

I create a separate table joined to main table, but unable to select the option from the menu to Sort By Column- Greyed out.

What am I missing. I just want a filter of Months (Jan, Feb, Mar, etc) in numeric order. Can someone direct me to a good how to?

6 Answers

If a sort has already been specified, it will be greyed out.

  1. Click on the Data icon in the upper left.
  2. Click on the column that may have a sort on it.
  3. Click Clear Sort.
  4. Click on another column, then click back to the column you want to sort.
  5. Sort By Column will no longer be greyed out.

When you create Report using Power bi data set (not connect directly to database) you cant use column sort it will appear disabled

This is an old post, however, I was not able to solve based on above answers. So updating based on what helped me.

In Power query editor, create a new column in the same table as month number for corresponding month. Apply the changes and return to report screen.

Month Number Column

In report screen, select the field "Month", go to modelling and click sort by "Month Number". Note:- this makes Month to be sorted based on Month number rather than alphabetical.

Select Field Month

Sort by Month Number

Related