Forum Discussion
Text filter plus measure
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! :)
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
3 Replies
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
