BI will not SORT visual correctly

[e175429]

Hello All!

I have a bar chart that shows a number of total activities for a given month and year. The chart starts with Feb 2022 and comes up to Feb 2023.

The order should be:

Feb-22

Apr-22

Jun-22

Aug-22

Oct-22

Nov22

Dec-22

Jan-23

Feb-23

When I sort ascending or decending, it always shows out of order.

I created the last 2 custom columns, MonthYear and RelativeMonth based on the Date column.

MonthYear  

= Date.ToText ([Date], "MMM-yy")

RelativeMonth

= 12 * Date.Year([Date]) * Date.Month([Date]) - 12 * Date.Year(DateToday) - Date.Month(DateToday)

(sn: I created a DateToday quiery)

MonthYear is formatted as Text. RelativeMonth is formatted as Whole Number.

I thought it would work by sorting the graph by MonthYear and then ascending or descending, but it's not working.

Any help will be greatly appreciated!

[e175429]

@Greg_Deckler thank you so much! that worked. I'm upset it was that simple smh

[Greg_Deckler · Accepted solution]

@e175429 Try using a numeric Sort By column.