Have you tried
When 2015 then ' 15/16'
When 2016 then ' 16/17'
When 2017 then ' 17/18'
When 2018 then ' 18/19'
When 2019 then ' 20/21'
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Automatically generated as in its a Dimension field with values listed as FY 2015, FY 2016, etc? If so you can give it an Alias and rename it to your choice of desired output.
1. Right click on the Pill listed in Dimension - select Aliases - a window will open-up allowing to Edit Aliases
2. Under the Value (Alias) column - enter desired text against each Member.
3. Click OK and the view will change automatically with updated Alias.
Sample of Edit Alias below from Superstore - Sub-Category
Thanks for responding and this looks exactly like what I need. However, I am relatively new to Tableau so when I tried this I changed my YEAR(F1) filter to a context filter and then typed in exactly what you outlined in the formula section of the condition tab of the edit filter selection. When I did that I got an error that said "Reference to an undefined field [Date]. Where am I departing from what you suggested or where should I enter the text you typed above?
Thanks again for your help.
You need to substitute date with your date field I can see from your picture its F1
Thanks for your response but the dates are not the labels for the tick marks they are the label for the year in which all the tick marks occur. The tick marks in this case are not dates but rather values.
Thanks again for trying to help.
OK. I am getting closer. I created a calculation that seems to work partially. In my original post I should have said that the fiscal year runs from September - August so the way your answer is structured Tableau chops up the graph when 2015 ends. I am guessing I need to add more to the CASE portion of the above to include months and then instead of just using the year to delineate which section gets the '15/16' I need to include something like When => 09/2015 and =< 08/2016 then '15/16'. I am going to try that and will mark this answer as correct if it works.