Data filter based on a value to the main data set column

[igotoshobybus]

Hi,

Thank you for assisting in advance. I been struggling for a while on this. 

I have a column in the main data set which has a combination of 4 words (one, two, three, four), example below. I want to be able to use the slicer with only the 4 unique values(Slicer A for example) to find which row contains the specific selected word / multiple word and filter the other table in the report as well. I tried a few approaches that I can find online including : 

1. Splitting the column in transform data, but then it increase the number of rows, which will affect other table data.

2. Creating a separate table and setting up the relationship but it is only able to find the exact match. 

Main table column

One Two

Two

One Three Four

Three Four

slicer A

One

Two

Three

Four

Please kindly advise 

[mostho · Accepted solution]

Splitting the column and joining with a helper table will work, look here.

[igotoshobybus]

Thanks! I took this as the final approach, taking a while to list out all possible options. 

[Fendiaz]

Hi, 

you can create support table to handle it, and make relation within tha two table, but you need to add index/unix column for that,  example,

Main table column	id
One Two	1
Two	2
One Three Four	3
Three Four	4

than you can create new table from query editor base from old table and split it, it;s oke if the create new row for this because it's not the main table,

the new table will be looks like this 

Split	ID
One	1
Two	1
Two	2
One	3
Three	3
Four	3
Three	4
Four	4

so you just need create relation betwen this two table and make a slicer filter from second table..

[igotoshobybus]

Interesting approach! but my main data set is dynamic, it keeps changing every hour.  And also I would need to use the main data column as I need to filter the rest of the table.

[Fendiaz]

ok, Good luck.

 my experience with this methode can handle my project with 30milion raw data, and the second table will automaticaly generate up to 80milion raw, and refresh automatically when data refreshed.