Forum Discussion
How to replace the value of x-axis based on another column
Given the data below: Column1 Column2 Value A_001 Alex 50 A_002 Alex 80 A_003 Betty 70 I am creating a column chart based on the data above. I put Column1 as my X-axis an...
>> Create New Column :
col1&col2 = CONCATENATE(replace_Table[Column1],CONCATENATE("/",replace_Table[Column2]))
If this post helps, please consider accept as solution to help other members find it more quickly.
Hi, I have thought of concatenating with other columns to make it an unique value. However, the text is just too long after the concatenation. Is there anyway to only show certain number of characters in the visual?
can you share sample output format.