Sort Month Name by Month Year ID Column

[aoc]

Hi all,

I am looking to sort my line graph by Month Name but have multiple years worth of data. Currently it is sorted by Month number and the most recent year is being sorted currectly, but the past year isnt. I have created an ID column with year and month number concatenated, but cannot sort by it since I would like the graph to show only the Month name, not the month-year (please see attached photo).

Any Solutions?

[TypimWuerfel]

HI @aoc,

it is possible to sort a column by another column.

step 1: select your column "Month Name"

step 2: go to column tools

step 3: sort by column (select your MonthId)

After that it should work.
____________________________

You want more helpful tipps and tricks like that?
Please subscribe: https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ 

[aoc]

Thank you for your response,

I have it being sorted by Month ID right now, and am getting the sorting shown in the photo.

[v-yiruan-msft]

Hi @aoc ,

Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards