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

Thanks for the reply,

yes, i want to represent BD and ID with two separate lines in the chart that's why am un-pivoting them separately.