How can you conditionally color the answers (i.e., the bars) based on the respondent's answers. For example, in the dummy data set, when "Ben Franklin" is selected in a dynamic parameter, his answers (i.e., bars) are colored grey, whereas all of the other bars (not his answers) are blue.
Note some questions are multi-select where multiple bars could be colored. I do not want to filter the results by this respondent - still show the aggregate answers, just conditionally color based on the respondent selected. Example of the conditional formatting is in the attached 'dummy screenshot'.
Appreciate if answers could be provided in the attached workbook for Dashboard 1 & Dashboard 2 and an explanation provided - ideally with screenshots. Thanks.
Hi @Marc Levy ,
You can do this by creating a parameter that dynamically updates to the list of respondents each time the workbook is opened, then a calculation like below will tag any answers that match, which can then be dragged to the colour mark so that it will change the colours for the selected respondent.
