Months instead of quaters

[mimi]

Hi

How do you show Jan-Mar; Apr-Jun, Jul-Sep; Oct-Dec  with their years instead of Quater 1, Quater 2, Quater3, Quater 4.

Power Bi automatically shows Quaters.

[edhans · Accepted solution]

Add a new column to your Dates table that has those labels for quarters vs the defaults, then use that field in your reports.

[edhans · Accepted solution]

Add a new column to your Dates table that has those labels for quarters vs the defaults, then use that field in your reports.

[mimi]

It is hard to put that new column in order. therefore that will not work for me

[mimi · Accepted solution]

However this solution works if I order the new column by thank for your help

oder number = Query1[InvoiceDate].[Year] & Query1[InvoiceDate].[QuarterNo]

thanks for your help