Arrange Months in sequence

[abd3127]

Hi Team,

I have a sharepoint list which has 12 differnt columns for the reqpective months (eg : Jan, Feb,..., Dec)

The data comes from a powerapp.

I want to show these 12 columns in my Power BI report so that data for particular month can be shown, I have used unpivot columns method here so that 1 record became 12 entries.

And I am able to show the 12 months in filter as shown in attached pic,

But these are not in sequence, they are either in ascending/ descending order.

Is there any way in which i can arrange these months in the sequence within the Power BI report.

Thanks

[Anonymous · Accepted solution]

Hi @abd3127,

I'd like to suggest you create a sort table with 'month' and 'sort order' columns(remember to setting 'sort by column' property), then create relationship with original table and use related month column to create visuals.

Custom Sorting in Power BI

Regards,
Xiaoxin Sheng