Sort columns

[Syndicate_Admin]

Hello, I have a table in this style:

Concept	January	February	December
A	50	30	5
B	100	10	9

Do I need to reorder so that the first column is December? Is this possible?

Thanks a lot

[danextian · Accepted solution]

Hi @Syndicate_Admin 

You data is not in the best format for reporting. It needs to be unpivoted first so the months will be in one column and the values in another.

Create a Month Sort column. The example below concanates the monh column with a year. Date.From parses the concatenation as a date. Date.Month returns the month number of the pased date.  Change the column type to whole number after.

Date.Month( Date.From( [Attribute] & " 2023") )

In the designer, select the month column, click sort by and select Month sort. The months should now be sorted properly.

[v-pnaroju-msft]

Hi Syndicate_Admin,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi Syndicate_Admin,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi Syndicate_Admin,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @SEMattis ,@danextian, for your response.

Hi Syndicate_Admin,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

In addition to the information provided by @danextian regarding better reporting and accurate month sorting in visuals, please find below the steps to reorder the columns so that December appears first.

1. Navigate to the Power Query Editor (Home → Transform Data).
2. In the Query Editor, select the December column.
3. Drag it to the far-left position, before January.
4. Click on 'Close & Apply'.

This will change the order of the columns in your data table but will not affect visuals or sorting in charts.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[Anonymous]

Hi @Syndicate_Admin ,

Did the reply offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.

Best regards,

Lucy Chen

[danextian · Accepted solution]

Hi @Syndicate_Admin 

You data is not in the best format for reporting. It needs to be unpivoted first so the months will be in one column and the values in another.

Create a Month Sort column. The example below concanates the monh column with a year. Date.From parses the concatenation as a date. Date.Month returns the month number of the pased date.  Change the column type to whole number after.

Date.Month( Date.From( [Attribute] & " 2023") )

In the designer, select the month column, click sort by and select Month sort. The months should now be sorted properly.

[SEMattis]

Hi! I would propose that you implement a new "Order" column in your table using the QueryEditor. A similar question and solution can be found here: Solved: How to reorder months so the graph matches fiscal ... - Microsoft Fabric Community