Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi, I have two tables. One of the text columns in the first table (A) has text values which are codes separated out by commas. The second table, B, has all of these distinct codes that form the entire column of table A, in rows of table B.
There is no relationship between the tables as there isn't a common ID, you can say Table B is a lookup table with the codes and the description.
My end goal is to have a slicer created from that code column from table B and it filters the visuals and data which are mainly created using table A.
eg: if one of the code in table B is 'Z36', one or more than one of the rows in that code column of table A could have 'Z36' by itself, or 'Z36', 'H12', or any combination with no limit on the number of codes for that row. I want to filter the data in table A such that for every occurence of that selected code from the slicer from table B, that occurence of that code fromtable A gets filtered and the visuals change accordingly.
Thank you!
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
141 | |
109 | |
69 | |
55 |