How to sort Quarters in Bar Chart?

[JDeMaro22]

Hello,

I have a bar chart my CEO needs this afternoon but I don't know how to sort the X axis by quarters. I need it to read Q1-2022, Q2, Q3, Q4 then Q1 2023. I'm sure it can be down within the data itself but I'm not sure how.

Thank you,

Joshua

[JDeMaro22]

I think this works.

Thanks a lot 

[Greg_Deckler]

@JDeMaro22 Going to depend on the structure of your data but in general construct a numeric column like this (DAX example):

Quarter Sort = YEAR([Date]) * 100 + QUARTER([Date])

Whatever your quarter column is, set it's Sort By column to this numeric column. Go to Data view, select your quarter column and in Column Tools set the Sort By column to Quarter Sort.

[JDeMaro22]

Sorry, and this is the measure for the quarters:

ReferralStartQuarter =

CONCATENATE("Q",Quarter(MART_REFERRAL[ReferralDateMerged]))&"-"&Year(MART_REFERRAL[ReferralDateMerged])

[Greg_Deckler]

@JDeMaro22 Try:

Quarter Sort Column in MART_REFERRAL Table = YEAR([ReferralDateMerged]) * 100 + QUARTER([ReferralDateMerged])

[JDeMaro22]

I apologize I'm new to writing DAX. I don't have a "date" column in this particular data set. In the picture above I'm using "ReferralStartQuarter". These are the date options I have: