Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rename value in segment

Hello everybody,

 

Simple question here, I have a segment used to filter data in my report.

 

I want to know if it is possible to rename the value in the segment select, in my case the value '0' and '1' which are in the database need to be replaced.

 

I know that I can replace the value in my models, but I have some calculated columns using those values, so I don't want to go and change them.

 

Thanks a lot !

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    We can create a calcualted column in the table to achieve your goal.

     

    State2 = SWITCH(Table1[State],0,"test1",1,"test2")

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

    We can create a calcualted column in the table to achieve your goal.

     

    State2 = SWITCH(Table1[State],0,"test1",1,"test2")

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous,

       

      Does that make sense? If so, kindly mark my answer as a solution to close the case.


      Regards,
      Frank