Forum Discussion

yodha's avatar
yodha
Helper IV
6 years ago
Solved

Un-Pivoting Data issues

  Hi, i have data in Excel file and i want to un-pivot it, to change columns to rows, but am unable to do it as expected  This is my excel File, and i have un-pivoted it in power bi like this,...
Need Help
Tips and Tricks
  • YJ's avatar
    YJ
    6 years ago

    There you go yodha :

    With pleasure

    PBIX ,

    Hope it helps

     

    Regards

yodha's avatar
yodha
Helper IV
6 years ago

If i un-pivot them together data is looking like this.But i dont want data like this, 

 

i want them in separate columns like this,

so that i can see values on my X-axis like Date BD1 ID1, Date BD2 ID2,  Date BD3 ID3, etc..,

All this i am doing to represent all my BD values in one line, and ID values in another line in the graph.

Thank you.

YJ's avatar
YJ
Resolver II
6 years ago

There you go yodha :

With pleasure

PBIX ,

Hope it helps

 

Regards

  • yodha's avatar
    yodha
    Helper IV
    6 years ago

    Thank you so much, able to achive the requirement now, help appreciated. :smileyhappy:

  • yodha's avatar
    yodha
    Helper IV
    6 years ago

    Hi YJ 

     

    While Merging Inner join is creating duplicate rows in the data.

     

    Thank you