Visual-level filters not working

[Solution1234]

Hello,

I'm relatively new to Power BI and have encountered a problem with visual level filtering that I'm struggling to solve.

My data is contained in a single table (survey responses from MS Forms), and category filtering using slicers works perfectly. However, the interactivity between my visuals isn't functioning as expected. When I click on a specific bar in one graph, the other graph doesn't update.

The data for one graph is derived from three separate measures that count the frequency of specific words in a column. The other graph uses data from three separate columns containing binary data (0 or 1). I also have a counter that updates when I use the slicer but doesn't change when I interact with the visuals.

All data is in one table, with each row having a unique ID.

I have tried all troubleshooting mentioned in this articel: https://www.quicklylearnpowerbi.com/blog/power-bi-card-visual-filter-not-working

I am not sure whether it is a problem with my data format or something else.

Hope to find some help here. Thanks a lot in advance!

[samratpbi]

Hi, without looking into the data, it is difficult to say what is going wrong. However few thoughts: first make sure interaction between visuals is enabled from Edit Interaction. Then since you have mentioned there is only one table, hence ideally there should not be any relationship issue. So look into your measures if those having any DAX function like ALL to ignore filter context.
If this helps to resolve your problem, then please mark it as solution, thanks

[Solution1234]

Hi,

thanks for the quick reply! I've tried Edit Interaction, looking at relationships (as said shouldn't be the case as one table), etc.

Data format of the left graph:

and I am using the following three measures to count each word:

Feedback_Important1 = CALCULATE(COUNTA('SheetData'[ID]), FILTER('SheetData', 'SheetData'[How important is customer feedback for you? (Select one)] = "Important"))

Feedback_Not very important1 = CALCULATE(COUNTA('SheetData'[ID]), FILTER('SheetData', 'SheetData'[How important is customer feedback for you? (Select one)] = "Not very important"))

Feedback_Very Important1 = CALCULATE(COUNTA('SheetData'[ID]), FILTER('SheetData', 'SheetData'[How important is customer feedback for you? (Select one)] = "Very important"))

The data for the right graph looks as follows: 

For the counter I am using the following measure:

Numbers = COUNT('SheetData'[ID])

Following some more pictures of the dashboard:

Hope this helps to identify a potential error! Thanks a lot for the help.

[v-xinc-msft]

Hi @Solution1234 ,

Could you please provide example data or sample files here? We could offer you more help if we have information in detail. And what you expect the output to be. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Solution1234]

Hi,

Thanks a lot for your reply!

I was able to narrow down the problem.

The problem is how to visualize multiple choice questions.

In my survey respondents are able to select up to three answers from nine answer possibilities, shown in the orange columns. I then created 9 columns (yellow) for each answer possibility and transcribed the answers binary, 0 or 1.

I thought by doing this I could just add all nine answer possibilities into one graph, however, doing this the functionality of visual filtering does not work because there is no Legend (I belive it is called "Attribute") meaning a column describing every row like "Adopting AI or Digital Solutions". I cannot just add this column because every row has up to three answer possibilities.

I have tried unpivoting the table but this means that the "ID" goes missing and will be dublicated nine times, for instance, a 1 will show up in the first nine rows. In addition, I cannot do this because I have several multiple choice questions in my survey with differing number of answers. This question will have to visually interact with three other questions.

I am not sure whether my general approach transcribing the answers makes sense or whether I could somehow start from my normal data in the orange columns!

Nonetheless, I now know the problem.

I hope sombody might have a hint on dealing with this! 

Data: 

ID	What are your top 3 strategic priorities for the next 12 months? (Select up to 3)	Answer 2	Answer 2	Adopting AI or Digital Solutions	Aligning with Sustainability Goals	Enhancing Customer Experience	Expanding into New Markets	Improving Existing Products/Services	Increasing Market Share	Increasing Profitability	Launching New Products/Services	Reducing Costs
1	Aligning with Sustainability Goals	Expanding into New Markets	Increasing Market Share	0	1	0	1	0	1	0	0	0
2	Increasing Profitability	Improving Existing Products/Services	Launching New Products/Services	0	0	0	0	1	0	1	1	0
3	Improving Existing Products/Services			0	0	0	0	1	0	0	0	0
4	Adopting AI or Digital Solutions	Increasing Market Share	Increasing Profitability	1	0	0	0	0	1	1	0	0
5	Adopting AI or Digital Solutions	Launching New Products/Services		1	0	0	0	0	0	0	1	0
6				0	0	0	0	0	0	0	0	0
7	Expanding into New Markets	Increasing Market Share		0	0	0	1	0	1	0	0	0
8	Increasing Market Share	Increasing Profitability	Launching New Products/Services	0	0	0	0	0	1	1	1	0
9	Increasing Market Share	Launching New Products/Services	Increasing Profitability	0	0	0	0	0	1	1	1	0

[v-xinc-msft · Accepted solution]

Hi @Solution1234 ,

Please follow the steps below.

1. First, make sure your data is properly formatted in Excel.

2. Unpivot the table. The data after inverse pivoting should look like the following:

3. Import the prepared data into Power BI.

4. In Power BI, you could create relationships to ensure interaction between different multiple-choice questions. Please create a new table and create relationship.

5. Now you could create visual charts in Power BI.

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Solution1234]

Hi Lucy,

Thanks a lot for your detailed reply. It helped bring me on the right track! I'll have to work with relationships and and create additional tables with relationships!

Furthermore, for anybody else dealing with problems analysing complex survey data with PowerBI I can recommend the following video, which helped me a lot! (Visualize complex survey data in Power BI)

[v-xinc-msft]

Hi @Solution1234 ,

I'm glad I was able to help, and thanks for sharing!

Regards,

Lucy Chen