Forum Discussion
change data text
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!
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.
3 Replies
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.
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.
This was exactly what I needed, thank you very much!
