Freeze X axis (Keep labels static)

[chintanmtt]

I am trying to make a line chart with a play axis which shows yield movements based on tenors (1 year, 2year...5 year). However based on the value of the yield, the x axis labels keep on changing. How do I make them static? See pictures for clarity.

I want tenors to start with 1Y and go up to 5Y and remain static.

[lbendlin]

Sort the line visual by the tenor column, not by the percentage value.  Use the ellipsis in the top right corner ( ... )