Format String for Quarters

DAX DAX Calculations
1

Is there a custom format string that can convert dates 01/01/2023 into Q1 23?

I dont’ want to lose my continuous axis so I dont’ want to convert the dates to text, just visually show the date as Q1 23, Q2 23 etc.

2

I don’t know if there is this option, but an alternative would be the one below. See if it helps you

  1. Create 2 columns as shown in the image
  2. Sort the QuarterName column by Quarter

image

image
image1090×503 35.6 KB