Forum Discussion
Separate Data based on date
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
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
v-lili6-msft As soon as I add index in visualize I see the column 'Index' turns into First or Last or Count like some kind of measure. How do I make this without a measure. Even if I change the type of 'Index' from Whole Number to Text, it still shows Count whenever I drop over to the Matrix visualization. How can I make sure it doesn't change the type of the Index to any measure when I drop it Values in Matrix.
Screenshot below: