Forum Discussion
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
- Anonymous8 years ago
Hi
Please make sure you have selected the Date column while you click the Unpivot opion.
3 Replies
- AnonymousNot applicable
Hi
Please make sure you have selected the Date column while you click the Unpivot opion.
- AnonymousNot applicable
Thanks alot everyone, its been so helpful
- StachuCommunity Champion
the transformation is not tedious, it's few clicks - in Edit Query you need to go to Transform, and then Unpivot Columns