change data text

[FrancoPS]

Hi!

I need to change the legend text of my graphic, it has numbers from 0 to 2, and i need to change to "completed" when is 0, "incompleted (back to menu)" when is 1, and "incompleted (logout)" when is 2.

img of the graphic, thanks in advance!

[Anonymous · Accepted solution]

Hi @FrancoPS ,

You can create a calculated column using SWITCH. Be careful not to add quotation marks around the numbers.

Column = SWITCH([legend],0,"completed",1,"incompleted (back to menu)",2,"incompleted (logout)")

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FrancoPS]

This was exactly what I needed, thank you very much!

[Greg_Deckler]

@FrancoPS Depending on your data, add a column in your data model to use a SWITCH statement to return the desired label based upon the column used in your legend. Use this column instead of the column you are currently using.