Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Managing textcodes in a Power BI column

Hello everyone,   I have a table with textcodes inside which looks like this :   MEX CAM_1 CAM_2 CAM_3 CAM_4 247442204431 C313-- C32DU1 C32F-- HORSCI 238029411820 C313-- C32F--...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    Agree with MarcelBeug. Clarify the issue can make us understand better and deliver prompt response. :smileyhappy:

     

    In your sceanrio, if there are another columns in the table, you can select columns CAM_1,CAM_2,CAM_3,CAM_4, then click Unpivot Columns. See:

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Anonymous,

 

Agree with MarcelBeug. Clarify the issue can make us understand better and deliver prompt response. :smileyhappy:

 

In your sceanrio, if there are another columns in the table, you can select columns CAM_1,CAM_2,CAM_3,CAM_4, then click Unpivot Columns. See:

 

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You are both right, I should have been more precise... Thank you both for your help, it does work :-)

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi Anonymous,

     

    Glad to hear the problem was gone. :smileyhappy:

     

    Would you please mark helpful replies as answers so that we can close this thread?

     

    Best Regards,
    Qiuyun Yu