Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm looking for some help with something I'm struggling with. I am using the text filter visual which uses table 2 phrase as the field. I am hoping to display a table visual whereby the items are returned when a phrase contains the query term typed in the search box. E.g. if a user types in phrase1, the table should display item1 and item2 from Table 1 (as I also want to display info from columns 2 and 3 from that table). Is there a way I can achieve this?
Table 1
item | column2 | column3 |
item1 | ||
item2 | ||
item3 |
Table 2
term | phrase | phrase_volume |
item1 | phrase1 | 100 |
item1 | phrase2 | 500 |
item1 | phrase3 | 300 |
item2 | phrase1 | 400 |
item2 | phrase5 | 500 |
item2 | phrase6 | 600 |
item3 | phrase7 | 500 |
item3 | phrase8 | 300 |
item3 | phrase9 | 400 |
Any help would be much appreciated! Thank you! 🙂
Solved! Go to Solution.
Hi @badger123,
For your requirement, you could create the relationship between table 1 and table 2 like below.
Then when you filter the phrase column in text filter, you should achieve your desired output.
Best Regards,
Cherry
Hi @badger123,
For your requirement, you could create the relationship between table 1 and table 2 like below.
Then when you filter the phrase column in text filter, you should achieve your desired output.
Best Regards,
Cherry
Awesome, thanks @v-piga-msft !
Quick question, is it possible to exclude the item from showing when the phrase searched is the same as the item? E.g. if item1 was a phrase and it was searched for, then item1 wouldn't appear in the table visual.
Hi @badger123,
It seems that you have another requirement, you'd better create another post so that people who may have the same question can find the solution directly.
Best Regards,
Cherry
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |