Re-ordering Months on a Graph

[BrianJ]

@5thGreen,

Welcome to the forum! I think you’ll find this to be a great resource and a really helpful community.

I think the solution here is just to sort your x-axis by the fiscal year column in your date table (also be sure that your date table is marked as a date table, so that the time intelligence functions work properly). Here are a couple of forum posts that address similar questions.

Short Month Column not sorting in Slicer

@AoakeP, If you sort Short Month by the MonthOfYear field (see screenshot below) it will put your slicer in correct order. MonthOfYear is just the month number without the year, which is what you need to avoid the error message you were getting. -Brian [image]

Filter Order in Visual

@robH, I’ve web scraped a simple example akin to your situation. In my example below, the only sort options in the visual are Player and Salary. But, suppose I want to sort the graph by Player Age? [image] Using the technique above, define the sort order for Player using Age: [image] Now, when I sort the original graphic by Player, instead of sorting alphabetically as is the default, it will sort by Age: [image] Hope this is helpful. Brian

If these don’t solve your problem, please post your PBIX file so that I can provide a more specific solution.

Thanks.

• Brian