Forum Discussion
Helper VSort the X-axis based on Fiscal year for two countries
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Helper Vlbendlin , I have uploaded the sample file to drive
https://drive.google.com/file/d/1i-xMqNpKrjgR1izPuq9EhF05qm3ze7gU/view?usp=sharing
Also, I have shared my expected output for X-axis
For the US X-axis should be sorted like below ( Starting from the last closed month, say March 2023)
P3, P2, P1, P12, P11, P10, P9, P8, P7, P6, P5, P4
For Non-US my X-axis should be sorted like below
P4,P3, P2, P1, P12, P11, P10, P9, P8, P7, P6, P5
On Y-axis you can can kept nay Measures say SalesAmount. I have provided the Fiscal Calendar that has data for both US and Non-US countries and their dates and Fiscal year , Fiscal Month and Fiscal Period etc