Forum Discussion
Anonymous
6 years agoNot applicable
Separate Data based on date
Hi I have the following data : I want to separate the data based on the date and create something as below: How can i make this as part of my visualization? I want to separate ...
- 6 years ago
HI, Anonymous
If you want to get it in basic data table:
1. You could use Pivot in Edit Queries
https://radacad.com/pivot-and-unpivot-with-power-bi
For your case, selected Index column then Pivot the column and choose "Don't Aggregate"
For example:
If you want to get it in visual, you could get it by matrix visual as below:
https://www.goodly.co.in/create-pivot-table-in-power-bi/
For example:
By the way, from your screenshot, why different url could be combined like below?
Best Regards,
Lin
Anonymous
6 years agoNot applicable
Can somebody please help on this?