X-Axis Change of Order for Fiscal Years

[AmyRob]

I have a clustered column chart to display the count of clients (the count of unique identifiers) for each fiscal year to visualize the number of clients we accept for our educational program. No matter what I try, the X-Axis is automatically reordered by the value of the Y-Axis, as shown in the screenshot below. I want the order to be in numerical order.

Let me go through the steps that I took. I am new to Power BI.

I have an 'Intake' table that contains all the client information with an application date attached. These dates are calendar year dates (data type: date). Each client has a unique identifier and an application date. 

I also created a 'Calendar' table, which looks like the screenshot below. It includes all the dates within the date range (2015 - 2030) that I need (data type: date). All application dates from the 'Intake' table fall under this range. And then I added Fical Years for each date (the data type of Fiscal Year is Text).

Then I connected those two tables with 'AcceptanceDate' and 'Date'.

Afterward, I added to column bar in the Report View with these data selected for X and Y axes.

I tried everything that I could find online to resolve this, including giving the calendar table another column for sortingOrder numbers and use that for "Sort by column'. 

I feel like I am missing something very simple here as I am a beginner. Your assistance is appreciated!!! 

[marcelsmaglhaes]

Hey @AmyRob ,

 To achieve the ordering by fiscal_year column, you need to Sort that column by the year column.  Check the image bellow and this link to more information: Sort one column by another column in Power BI - Power BI | Microsoft Learn
After you sort the column, you will be able to orderer your graph.

If this post helps, please mark as solved. 

Regards, 
Marcel

[AmyRob]

Could you show me what your 'sales' table looks like? I honestly don't know what I am doing wrong here.

[AmyRob]

Thank you for the reply. But I get this error message. 

[marcelsmaglhaes]

You can't have same year to differents fiscal_year. For example, 2018 - FY2018/2019 and 2019 - FY2018/2019. Its have to be 2018 - FY2018/2019 and 2019 - FY2019/2020. Check you date to assure you dind't have this situation. If you have and its necessary have to, you will need create a index column to the year column (Sort a Column with a Custom Order in Power BI - RADACAD)

[AmyRob]

I created an index column for sorting order. So for example, all FY15/16 are given 1, FY16/17 are given 2. 

And I went to the Report View, clicked on FiscalYear, clicked on Sort by column, and chose FY Sorting Order. But it does not do anything. 

[marcelsmaglhaes]

Maybe you need change the sort in the graph. Take a look: Change how a chart is sorted in a report - Power BI | Microsoft Learn