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 Everyone,
New power BI user here. Basically what I want to do is have a user select 2 values on same column and have the output be the common IDs on another column
Selections | IDs |
A | One |
B | two |
C | Three |
D | One |
E | Two |
F | Three |
G | One |
H | Two |
Suppose a user selects in a Slicer1 "A" and "B" and in Slicer2 "G" then I want to output to show (in matrix or whatever) "One"
Suppose a user selects in slicer1 "C" and in Slicer 2 "D" then the output should be nothing
Suppose a user selects in Slicer1 "A","B","C" and in Slicer2 "B","F" then output should be "two" and "three" etc
Ideally I dont want to dublicate tables/columns (but can live with it if there is no other way) as its a large data set and dont want to affect performance.
Thanks.
Thanks for the reply.
One quick question is assume I cannot create a realtionship between the 2 filter tables (and cannot go to qurey editor to create a relationship) and the Main table is there a way to do this then?
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |