Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Drop down menu from different columns

Hello Everyone

I am new to Power BI

I am facing following problem, any help will be highly appreciated.

 

I am working on survey results.

I have my demogaphics data as a separate table.

And all responses stored in a separate table as a long data.

In demographics table I have following columns 'Gender'  'Age Group'  'Region' etc

When I am showing response data I want to have above mentioned columns as a dropdown menu.

 Any idea how it can be done and how should I organize my initial data

 Thanks!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak 

     

    Thank you for your suggestion, it helped me to resolve other issue.

    What I am trying to achive is have a clustered bar chart with two level dimention(like in matrix table)

    So somthing like this :

    Anwer Options   Gender

    ___________________________

    Answer Option1  Male

                                Female

    Answer option2   Male

                                Female

    And I need to have drop down menu to be able to change Gender to other options like Region/Age Group

    My Drop down will have Gender/Region/Age Group etc.

    Can you help me with this?