Cross-highlighting visuals: how to best structure survey data?

[zacksg1]

Hi!

My dataset includes survey data (say 100 rows of survey responses and 10 columns of responses). 

I've unpivoted.....so, 1000 rows which each include a question value (1-10) and an answer value (A,B,C,D), plus an ID (1-100) to indicate which of the original 100 responses it originated from). 

This setup enables me to easily set up measures and create all of the visuals I need (great!).

However, I'd like to be able to cross-highlight (or possibly cross-filter) a few of the visuals, and I'm struggling with how to get that set up properly. 

For example, I have stacked column chart that displays the % of responses for (A,B,C,D) for question #1. I'd like users to be able to click on that chart--selecting option C, let's say--and have this cross-highlight or cross-filter all of the other visuals to only include survey responses for which the answer to question 1 was C. Because I've unpivoted, when I select C, everything related to other questions goes blank, since it only keeps (unpivoted) rows with Question=1 and Answer=C.

How do I (re-)structure my data and/or tweak the visual interactions setting to enable that? 

Thanks!

[Seppevangils]

Have you found a solution for this yet? I struggle with the same issue. Thx!

[zacksg1]

Hi! 

The visual on the left is one particular survey question. The visual on the right is 4 particular survey questions.

I want users to be able to click the red area on the left  and have this cross-filter or cross-highlight the visual on the right, such that the data on the right only includes survey responses for which the person's answer was red for the left question. 

[parry2k]

@zacksg1 so what is happening when you click on red now? Sorry just trying to wrap my head around. If possible can you share sample pbix file, remove sensitive info before sharing.

[zacksg1]

When I click on the left graph, the data on the right graph disappears. 

[parry2k]

@zacksg1 unpivot is the best way to go for it, but I'm not clear what you are trying to achieve if you can share a screenshot and required behaviour it will help.