Hi There,

I am trying to figure out how to sort by Fiscal month (October to September) within the Integrated Power bi report within Lists.

I have a Column (choice) in text format that lists October, November, Dec, etc.

When i create the Power Bi report though lists, I want to display the monthly sales by our fiscal year (October through September) but it automatically sorts it by largest sales revenue month to smallest.

I am assuming I need to create a calculated column in lists that displays fiscal month by number IE October = 1 December =2 etc but I don’t know how to male this work.

Any help would be appreciated.

Thank you

​Hi There, I am trying to figure out how to sort by Fiscal month (October to September) within the Integrated Power bi report within Lists. I have a Column (choice) in text format that lists October, November, Dec, etc. When i create the Power Bi report though lists, I want to display the monthly sales by our fiscal year (October through September) but it automatically sorts it by largest sales revenue month to smallest. I am assuming I need to create a calculated column in lists that displays fiscal month by number IE October = 1 December =2 etc but I don’t know how to male this work. Any help would be appreciated. Thank you     Read More

​