Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |