BI will not SORT visual correctly

e175429 — Thu, 16 Mar 2023 15:59:13 GMT

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!

Re: BI will not SORT visual correctly

Greg_Deckler — Thu, 16 Mar 2023 16:07:13 GMT

e175429 Try using a numeric Sort By column.

e175429 — Thu, 16 Mar 2023 16:25:38 GMT

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