Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to replace column values in power bi

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

Monthly45000
Monthly20000
Monthly17000
Monthly18000
Monthly18000
Monthly9000
Monthly8943
Monthly3456
Monthly1690
Monthly1600
Monthly12300

 

 

Need Help
  • rocky09's avatar
    rocky09
    4 years ago

    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.

     

3 Replies

  • rocky09's avatar
    rocky09
    Icon for Solution Sage rankSolution Sage
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi rocky09 , Yes in the same column itself

      • rocky09's avatar
        rocky09
        Icon for Solution Sage rankSolution Sage
        4 years ago

        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.