Forum Discussion
Visual-level filters not working
Hi Anonymous ,
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.
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
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.
Hi Anonymous ,
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.
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 Hi Anonymous ,
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.