Forum Discussion
wshenc26
3 years agoRegular Visitor
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 and Value as my Y-axis.
However, I do not want the X-axis value to show as A_001/A_002. I would like it to show the name such as Alex in Column2.
I cannot put Column2 as my X-axis because there are chances of identical values as shown in the table, which will merge and stack up the value by Power Bi.
Can anyone advise?