Forum Discussion
Comma Separated Value and drill through
Hello,
Is there are a way to do a drill through with a comma seperated value and return everything that has one of the two comma seperated values in their column? So I have 2 columns. SubSegment1 & SubSegment2. I concatenate the two on the main report and want to create a drill through that filters based on either of the two values and not just the combined value of it. If I have Test 1, Test 2 and I drill into my report I want it to filter and show me any SubSegement with either Test 1 or Test 2. Any assistance would be apprecieated.
Thanks
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.
3 Replies
- amitchandak
Super User
mlisi , 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.
