Forum Discussion
Comma Separated Value and drill through
Hi mlisi ,
If you want to keep your source table, you can create a duplicate table in power query and unpivot other columns:
Create relationship between these tables and set drillthrough for it.
Drillthrough pageTarget page
If you do not want to keep the source table, just unpivot it directly to use drillthrough.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Usermlisi , you can use individual values to dill, not the comma-separated one to dill partially, You can create a report service URL but that will open In new window https://docs.microsoft.com/en-us/power-bi/service-url-filters
Thanks! What if I kept the two columns seperated. Is it possible with an out of the box drill through to have SubSegment1 filter both SubSegment1 and SubSegment2 and SubSegment 2 filter SubSegment 1 and SubSegment2 in the drill through page?
v-yingjlCommunity Support
Hi mlisi ,
If you want to keep your source table, you can create a duplicate table in power query and unpivot other columns:
Create relationship between these tables and set drillthrough for it.
Drillthrough pageTarget page
If you do not want to keep the source table, just unpivot it directly to use drillthrough.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.