Don't think you can.
Or, at least, you can't alter the kludgy way Tableau labels fiscal years. Every company I ever worked for ran a fiscal year April to March and formatted their reporting as "FY YYYY-YY". I've not found an intuitive way of doing this, other than creating calculated fields to act as the labeling.
But I am calling the Revised Date calculated field by a parameter.
Parameter - has various string values such as Year, Category, Supplier etc
the corresponding Calculated field contains the case for calling the string and render the data.
Now when i use the year case it still returns the year and not the fiscal year
Revised date when used in the rows: it shows the FY correctly
But in the case function does give only the calendar year.
The dimension calculation is given below:
What do i change to get the FY label in the first snapshot?
So D_DIM1 is essentially a dynamic field which will change according to your parameter, and it will always output a string (whether it be a string of a date or a category)?
If so, then you could alter the D_DIM1 calculated field to read:
WHEN [Year] THEN
"FY " + str(year([Order Date]))
WHEN "Category" THEN
Or if the particular date formatting your organisation adheres to is similar to my own (FY YYYY/YY), you could style it as:
"FY " + str(year([Order Date])) + "/" + right(str(year([Order Date])+1),2)
I guess i kind of missed the point that i was trying to solve.
in the pic:
you see that the Year of Revision is showing correct values as FY 2008 etc.. but when i use the same dimension as a case in the parameter it comes as 2008, as its taking the calendar year, so i guess i need to change something in the calculated measure other than just adding FY..
if i add FY to the label: it doesnt give the correct value: