Forum Discussion

yodha's avatar
yodha
Icon for Helper IV rankHelper 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
Icon for Solution Sage rankSolution 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