Forum Discussion
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.
3 Replies
- amitchandak
Super User
The 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
fanhui3Hi, Thanks for replying. So below is one of the chart in my dashboard. I would like to replace "2020" with "TTM".
v-yuta-msftCommunity Support
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.
