SueC
SueC

Reputation: 13

Tableau: sort month on fiscal or calendar year parameter

I have added a parameter to select either fiscal or calendar year. I have a year over year line graph and since the fiscal year begins in July I would like July to be the first month listed on the axis when fiscal year is selected. Right now the months display January to December.

Upvotes: 0

Views: 729

Answers (2)

Andy TAR Sols
Andy TAR Sols

Reputation: 1735

Fiscal dates in Tableau are best managed using standard date functions. In this case your fiscal date would be a DATEADD of 7 months: DATEADD('month',7,[Order Date])

Upvotes: 0

Siva
Siva

Reputation: 9101

You can change the fiscal year by changing the fiscal year start to June

Check below image

enter image description here

Upvotes: 1

Related Questions