Forum Discussion
Filter data and from one table based on data another table and create a slicer from the second table
Hey Simaant ,
what did you try so far to solve it? Where are you struggling?
Isn't that the same problem as in this post:
Check the uploaded solution file, I think that is what you need.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn
Hi selimovd , Thank you so much for your prompt response. This looks like the closest solution to my problem and I'm going to give it a try here, Let me get back to you with an answer, i'm hopeful this will work.
selimovd sorry about the late response, but I tried it and i'm stuck at the step where I have to use a delimiter. My code column in table A just has values separated by commas. However, the number of values in there can be dynamic (can be 2 or can be as large as 50, separated by commas). I used the split by delimiter function but somehow it is just allowing me to create just one additional and isnt creating columns equal to dynamic columns with max being max number of values in the code column. I think the B-G use case you explained is not applicable in my case, I'm just trying the rest of the solution