X Axis Labels to Show month range instead of quarter.

[Chainfire74]

Instead of showing q1/q2 etc... I'd like it to show Apr 22-Jun22 etc..

Is this possible?

Thanks

[v-xiaotang · Accepted solution]

Hi @Chainfire74 

Thanks for reaching out to us.

>> to show Apr 22-Jun22 

You can try this,

OR  

you can create a calendar table, then customize YM column

MMM YY = FORMAT('calendar'[Date],"mmm yy")

in this way, don't forget to sort [MMM YY] by [YM]

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Chainfire74 , Create a column Start Date of Quarter and then Create month from that

Start Date Qtr = startofquarter([Date])

or

eomonth(_max,-1* if( mod(Month([Date]),3) =0,3,mod(Month([Date]),3)))+1

Then,a new column

Format([Start Date Qtr], "mmm-yyyy")

[Chainfire74]

Sorry, fairly new so still getting to grips with the basics.

I've tried adding the date 01/04/2022 in the date section in this formula: Start Date Qtr = startofquarter([Date])

But it didn't work, what should I put in there?

Thanks