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.
Hi
I am relatively new to PowerBI. Hope you can help.
Table Opportunities
Opportunity ID | Sales Team (coming from Opp owner) | Sales Team (coming from Revenue responsible) |
XjxjxjxhxA | Team A | Team A |
XjxjxjxhxB | Team B | Team B |
XjxjxjxhxC | Team A | Team B |
XjxjxjxhxD | Team B | Team A |
Now I'd like to apply a Filter visual on Sales team. However, it should filter on both columns.
Let's say we filter on Sales Team = Team A, the expected result should be:
Opportunity ID | Sales Team (coming from Opp owner) | Sales Team (coming from Revenue responsible) |
XjxjxjxhxA | Team A | Team A |
XjxjxjxhxC | Team A | Team B |
XjxjxjxhxD | Team B | Team A |
Any idea? Thanks in advance..
Hi @omelei86,
Current power bi does not support the 'OR' logic filter, you can create an unconnected table as the source of the slicer.
Then you can write a measure formula to extract the selection from the filter and compare it with current records and return flags, this formula can be used on the 'visual level filter' to filter records.
Regards,
Xiaoxin Sheng
Hi,
Write a RELATED() function in Table2 to bring over the Sales Team column from Table1. Create your visuals from Table2.
@omelei86
Hope the following video could be of help;
https://www.youtube.com/watch?v=WFJThyfQt-A
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |