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

YJ's avatar
YJ
Resolver II
6 years ago

Hi,

what do you mean by " i need BD values also to change like ID values."?

From what i see your axis is Date DB1 ID1, Date DB1 ID10, Date DB1 ID2 etc etc so yes the BD would not change until it changes.

What do you wnat to see in your X axis? (Date DB1 ID1, Date DB2 ID2 ) or (Date Sum(All DB), Date Sum(All ID) ??

 

regards

 

  • yodha's avatar
    yodha
    Helper IV
    6 years ago

    Thanks for the reply and i want to see in X axis like this (Date BD1 ID1, Date BD2 ID2, Date BD3,ID3, etc.., )