Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Visual-level filters not working

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!

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

7 Replies

  • samratpbi's avatar
    samratpbi
    Super User
    1 year ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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.