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

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi yodha ,

 

 

Is there a reason to unpivot separately the ID and BD columns?

What if you unpivot them together, does the chart work in that case?

 

Unpivoting them together means you will have the following columns:

- date

- attribute (both ID and BD)

- value (both ID and BD)

 

if you need a way to separate ID from BD you can create one more column using the Text.Start M formula. You can find more info on that here.

 

Let me know if this helps you.

 

Regards,

 

LC

Interested in learning Power BI and DAX? Check out my blog at www.finance-bi.com

 

 

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