Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Transpose table column values

Hello All, I have a table which is having three columns as below.   Now i would like to conver this table as  Is it possible with powerbi. Any suggestions.   Thanks you Mohan V.   ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    Based on my test about Greg_Deckler's Power Query code, it can achieve your requirement, see:

     

     

    Also you can select "Current Status" and "Next Action" columns then click Unpivot Columns, then use matrix visual to display data. 

     

     

    Best Regards,
    Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

thanks for the reply Greg_Deckler.

I did tried this already.

But it dosent matches with my requirement.

Can you suggest any other way please.

 

thank you.

Mohan V

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

Hi Anonymous,

 

Based on my test about Greg_Deckler's Power Query code, it can achieve your requirement, see:

 

 

Also you can select "Current Status" and "Next Action" columns then click Unpivot Columns, then use matrix visual to display data. 

 

 

Best Regards,
Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-qiuyu-msft,Greg_Deckler

     

    I have the same issue but in my scenario am having more than 10 attributes,

     

    If we have have 2 attributes the code is working.

    How to show in a matrix if we have more than 10 attributes?

     

    Please help me ASAP.

     

     

    Regards,

    Suresh Pantra.