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...
I have added an index column in Power Query and concatenated it with your Column2, to create a column named "Custom".
Required Output:
Note: You won't be able to eradicate "1-" ; "2-" and achieve the required outputs.
Steps:
You can follow the below images to achieve the required output.
Thank You.
If this solution answers your question, do mark it as Solved.
Hi, thank you for your answer. However, the index 1, 2, 3 in the text doesn't seem clean to me. But thanks anyway!