Forum Discussion
How to sort Quarters in Bar Chart?
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 d...
Sorry, and this is the measure for the quarters:
ReferralStartQuarter =
CONCATENATE("Q",Quarter(MART_REFERRAL[ReferralDateMerged]))&"-"&Year(MART_REFERRAL[ReferralDateMerged])
Greg_Deckler
Community Champion
Community ChampionJDeMaro22 Try:
Quarter Sort Column in MART_REFERRAL Table = YEAR([ReferralDateMerged]) * 100 + QUARTER([ReferralDateMerged])