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 trying to filter a table by a score (measure)
Say select a student B and his score is 60 I would like the table to bring back all of the students that have the same score;
Any help will be great.
Thanks
Solved! Go to Solution.
@Anonymous This could be a possible workaround:
Create the above visuals and edit interaction of Student Fi;ter and Table.
- Now when you select a student, the mark is going to be highlighted in the card, but the table values would not change as you have editted interaction. ( At the same time your score filter would change)
- Now select 60 in the slicer and then the table would give you a list of students in that score.
* *Just a workaround, and they would all make better sense if the visuals are arranged accordingly with proper headers (Say select a student of your choice and then a score)
Hey @Anonymous
could you show how score is calculated?
Student Score
Student A | 50 |
Student B | 60 |
Student C | 60 |
Student D | 60 |
And the end result would be like below;
@Anonymous This could be a possible workaround:
Create the above visuals and edit interaction of Student Fi;ter and Table.
- Now when you select a student, the mark is going to be highlighted in the card, but the table values would not change as you have editted interaction. ( At the same time your score filter would change)
- Now select 60 in the slicer and then the table would give you a list of students in that score.
* *Just a workaround, and they would all make better sense if the visuals are arranged accordingly with proper headers (Say select a student of your choice and then a score)
Hi @Anonymous
Yep this is kinda the first route that i went down, but really they want it in one click ( you know what users are like).
But i am unsure if there is a solution as you are unable to have a measure directly in the visual.
Thanks
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 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |