Rename value in segment

[Anonymous]

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 !

[v-frfei-msft · Accepted solution]

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]

Hi @Anonymous,

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

Regards,
Frank