Forum Discussion
Arrange Months in sequence
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
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.
Regards,
Xiaoxin Sheng
1 Reply
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.
Regards,
Xiaoxin Sheng