How to replace column values in power bi

[Sathvik123]

Hello All,

I have a table having data like below.

Is it possible to replace Monthly with Quarterly for the same column  inside power bi.

TrendTypeSales

Monthly	45000
Monthly	20000
Monthly	17000
Monthly	18000
Monthly	18000
Monthly	9000
Monthly	8943
Monthly	3456
Monthly	1690
Monthly	1600
Monthly	12300

[rocky09]

do you mean Instead of "Monthly" you want to replace it with "Quarterly" ?

[Sathvik123]

Hi @rocky09 , Yes in the same column itself

[rocky09 · Accepted solution]

If I understood your question properly,
Go to Query Editor --> Select Column that you want to replace --> right-click --> Click on Replace values like this.