Setting 12 month display in Timeline by Queryon

Hi Umlungu ,

You need to set up a calendar table. There's plenty of tutorials available on how to do this, but you will need to create a column for financial periods (I assume this is why you want Jul-Jun).

Once you have your date column for your calendar table in Power Query, you would add a new custom column and put this as the calculation:

if Date.Month([date]) >=7 then Date.Month([date])-6 else Date.Month([date])+6

In DAX it would be this:

IF(
    MONTH(calendar[date]) >= 7,
    MONTH(calendar[date]) - 6,
    MONTH(calendar[date]) + 6
)

This will give you your financial period number for each month.

Once you add a [monthName] field into your calendar table, in the data view for your calendar you can select [monthName], go to 'Sort by column' on the ribbon and sort by [financialPeriod].

Relate calendar[date] to fact[date] in the model screen, then use calendar[monthName] in any visuals. This will sort the month names July-June.

Pete