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
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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?