Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to filter my Power BI visuals based on specific tags from words table Tags1.pbix.
Here's the SQL query I'm working with:
SELECT title from meta m
left JOIN keywords k on m.id = k.id
left join words w on k.word = w.[index-tag] where tag = N'News'
INTERSECT
SELECT title from meta m
left JOIN keywords k on m.id = k.id
left join words w on k.word = w.[index-tag] where tag = N'Palestine'
I want to replicate this filtering behavior in Power BI visuals. I've tried using filters, but I can't seem to get it to work properly
Any suggestions on how to achieve this in Power BI?
Hi,
Share some data to work with, explain the question and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Your tag will always compute to false, as the tag can only be A OR B, not A and B. You were looking for "contains" maybe ?
unfortunately it's not a "contains", tags are made up of a single word
Then switch to "OR"
She is asking for AND. How to get to those rows that have both A AND B, not A or B.
That would only work if you use advanced filtering in the filter pane, or many disconnected tables.
even advanced filtering doesn't work, you can try the pbix file.
What do you mean by disconnected tables, do you have a specific solution to propose?
The PBIX does not have sufficient data for a DAX solution - the tags are not contained in the title. If you want fuzzy matching you need to use Power Query or external tools.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |