Forum Discussion
Data filter based on a value to the main data set column
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
5 Replies
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..
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.
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.
Thanks! I took this as the final approach, taking a while to list out all possible options.
