Forum Discussion
Partial Filtering based on user selection
Im trying to do partial filtering based on user selection on a report.
A crude example is in the attached.
Top left table is count of attendees, and shows how many events each attendee was associated with.
Table below this is a Status Breakdown, showing the statuses of each attendee for each event.
What i want is partial filtering, so when a user selects an attendee in the top table, the lower table is filtered by the Event, but not the Attendee.
e.g. User selects Anita in the "Attendee Counts" table.
"Status breakdown" table should show all attendees for events that Anita attended, i.e. it should ignore the Attendee filter context.
Default behavior is instead just to show rows for Anita in the "status berakdown" table as its filering on Event and Attendee.
As my status breakdown table doesnt have a measure i cant use calculate with various filters to do this. Is there a way this can be done in the front end?
Hi wilson_smyth,
I'm afraid your requirement is not achievable.
When you select a attendee name in top table, the dataset can be displayed on report visual is filtered related to this attendee. In other words, all other records related to other attendees are filtered out. It is not possible show all attendees for events that Anita attended.
Regards,
Yuliana Gu
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi wilson_smyth,
I'm afraid your requirement is not achievable.
When you select a attendee name in top table, the dataset can be displayed on report visual is filtered related to this attendee. In other words, all other records related to other attendees are filtered out. It is not possible show all attendees for events that Anita attended.
Regards,
Yuliana Gu