Forum Discussion
fanhui3
Helper I
Helper Ichanging one value in x-axis
My current year value in x-axis goes like this: 2010,2011,2012.....2020. I would like to change 2020 to be TTM. How do I go about doing so? Thank you.
fanhui3 ,
In query editor, click Transform-> Replace as below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserThe information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
fanhui3Helper I
Helper IHi, Thanks for replying. So below is one of the chart in my dashboard. I would like to replace "2020" with "TTM".