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...
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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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)

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

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

Regards,

Lucy Chen