How to lable x-axis in chart?

[Breezy]

Hi, for my example chart below (copied from a random page on the internet), how do I change: 2015, 2016, 2017 to label 

Y2015,Y2016,Y2017? How do I add the letter Y to the front?

[Or]

'Y' & Year, perhaps?

Might be a good idea to use Dual - Dual('Y' & Year, Year) - to keep the underlying numeric value.

[ogster1974 · Accepted solution]

Create a calculated dimension ='Y'& [Year] as a master Item and use that are your dimension.

[Breezy]

Ok, I just made a master dimension for:

Master items -> dimension-> create new->field

'Y'&([Year])

When I go into my chart it does not appear as a field in the dropdown menu though. 

[ogster1974]

Did your Master Item error on creation of the expression?

Can you confirm the Dimension has been created successfully?

Can you screen shot it? Can you use it in a table chart?

[Breezy]

You recommended 

Create a calculated dimension ='Y'& [Year]

I realize I can't use 'Year' since that is not the dimension. The dimension is 'Products'. My above chart is only an example but my real chart will not have Years as the x-axis. I was hoping there would be a formula that applies to all x-axis regardless of the dimension. 

[ogster1974]

From the look of your asks you are doing a simple sum(Sales) by Year and Product in a Grouped Bar Chart. Your ask was to add a Y to the Year Dimension.

Sounds straight forward enough.

[Breezy]

I still can't get each each item on the x-axis to have the letter Y in front of them. Think of it this way - if it were not years on the x-axis - if instead it were animals: cat, dog, frog, I would want it to be Ycat, Ydog, Yfrog. 

[ogster1974]

I get the ask perhaps need to see more of your example to see where you're getting stuck. Screen shot scribble out any sensitive data in the snippet.

My solution would be the same. ='Y' & Animals as a calculated dimension in master items then add to chart.  What are you actually getting when trying to apply this solution It might help our understanding more and we can assist you better?

[Breezy]

I got it now! Working 🙂

Thanks for your assistance!