Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Better Option to select Fields?

Hi, New PowerBI user converting from Tableau.    I have an Excel data source that has sales measures for latest 4, 13, 26 and 52 weeks. The problem is that my data fields are already labeled as SAL...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous you need to transform the data in unpivot format to achieve it.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi parry2k.....Since I am new to PowerBI I have no idea how to do that. Any help is appreciated!

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous may be bit hard to explain here if you can share sample data/pbix file (remove sensitive info before sharing) and I will get you the solution.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, How can I share the pbix file? I tried to figure it out and can't seem to locate where to attach?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Still looking for help on how to complete the Power Query portion of this. I took parry2k steps and then started applying to my entire data source but I am stuck. How can I share my whole bi file and anyone else who could assist me?