Forum Discussion
'Select All' equivalent for Simple Table Visual
I have two tables - one with survey data and the other with respondent IDs. I'd like to find out who responded to a specific question option and then refilter the survey table to only their responses. So for example, I have 750 respondents and a question about age group. I want to select the < 22 years option, find the 24 unique IDs and see how that group responded to the rest of the survey.
CTRL+CLICKing on the UUID table solves this but it's really cumbersome for larger sets. I really wish there was a select all option.
This app solves the problem but it has a large, really annoying watermark plastered across it:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104382000?tab=overview
Thanks for the help!
amitchandak I want to have the option to filter on any response category. This table contains hundreds of options among dozens of surveys so the Slicer itself would need to be filtered based on the selection.
So in my example, I'd like to then be able to expand the State question and see responses only from people in California.So UUID needs to populate on selection and then I need to choose that population to repopulate the Survey table.
4 Replies
nckpedersen , Is there a reason, you do not want to use a slicer? as you are showing only one value. You can disable multi-select with the customer (click will add) and add select all
amitchandak I want to have the option to filter on any response category. This table contains hundreds of options among dozens of surveys so the Slicer itself would need to be filtered based on the selection.
So in my example, I'd like to then be able to expand the State question and see responses only from people in California.So UUID needs to populate on selection and then I need to choose that population to repopulate the Survey table.
Hi nckpedersen ,
Does Hierarchy slicer fit your requirement?
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380820?tab=overview
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
Thank you, Kelly! I had to edit the interaction but this absolutely fits the bill. Appreciate the assistance!
