Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Preparing some data

  I am trying to put this data in Power BI . Its a date for a sales event split by each group. How can I use a slicer so that whenever I choose any group I can see the graph changing for the sal...
  • Stachu's avatar
    Stachu
    8 years ago

    the transformation is not tedious, it's few clicks - in Edit Query you need to go to Transform, and then Unpivot Columns

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

    Please make sure you have selected the Date column while you click the Unpivot opion.

     

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

the transformation is not tedious, it's few clicks - in Edit Query you need to go to Transform, and then Unpivot Columns