Change the Label to text (from year)

[GAPER]

Currently the last value (2050) is an average of all the previous years. I did a hack by creating additional roles in the data base where year is 2050. However, I would like to make the 2050 to "overall" but overall is not a number which messed up my x axis ordering. Is there a way i can change it to "Overall" while the y axis know how to sort it in asecnding manner and the "Overall" always appearing to the far right end? 

[GAPER]

Sorry I don't seem to understand

[RossEdwards · Accepted solution]

In your data set you have a column with all of the Year numbers. Its the column you put into this graph to be one of your Axis.

Create a new dax column with the logic of

IF([YearColumn] = 2050, "Overall", [YearColumn]

(Where [YearColumn] is replaced with the name of your actual column containing year values.

After creating this column, make sure its selected and look for a menu called "Column Tools". There is an option in there called "Sort By Column", click on that and select the YearColumn.

Put this new column on your graph axis instead.

[RossEdwards]

Yes!  In the same table as your years, create a new column which is text and all of the year values are the same, except make the 2050 text value say "Overall".  With that column created, use the column tools to tell it to "Sort By" and select the years column.  This will put Overall at the end.