Preparing some data

[Anonymous]

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

[Stachu · Accepted solution]

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

[Anonymous · Accepted solution]

Hi

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

[Anonymous]

Thanks alot everyone, its been so helpful

[Stachu · Accepted solution]

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