Forum Discussion

mlisi's avatar
mlisi
New Member
5 years ago
Solved

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.  SubSegmen...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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.

mlisi's avatar
mlisi
New Member
5 years ago

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-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

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.