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.
I have three different survey types (trainer, people leader, and 30 day survey that I'm putting on this page, each in different tables. I have slicers created but they are not connecting, Im sure it's a relationship issue but I can't seem to figure it out. Please see recruitment-onboarding tab. https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf?e=56kx5j
Solved! Go to Solution.
Hi , @jcastr02
Take these two tables as an example.
Need to create a corresponding many-to-many relationship as below , and the filtering effect can be generated.
Best Regards,
Community Support Team _ Eason
Hi , @jcastr02
Take these two tables as an example.
Need to create a corresponding many-to-many relationship as below , and the filtering effect can be generated.
Best Regards,
Community Support Team _ Eason
Can you explain your logic in the "Function Lead Survey" are of the relationships? I can't make sinse of what is going of there with the " - Start Time" table especially.
@Anonymous yes the relationship for the start time is so that I only have 1 table with the unique values to tie to the rest of the visuals within the People Leader tab. I used this solution to make sure that slicers worked on that tab (People Leader).
@Anonymous to add --had to do this to be able to sort each of the visual with comments from most recent to least recent < if i sort in my master file, all other items will unsort - so created seperate tables for each free response to be able to sort appropriately.
Interesting... I think it has something to do with this:
What is the purpose of those 5 blank columns?
@Anonymous I saw that as well, I deleted the columns but still having same issue.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |