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 sales of that group only across the date frame.

 

The only way I see it is that I need to edit the original data so that I can have three transactions per date, but that seems to be tidious. Can anyone help

  • 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.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks alot everyone, its been so helpful

  • Stachu's avatar
    Stachu
    Community Champion

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