Dropdown/Slicer for Questions and Visuals

[cspowerbi]

I'm trying to find a solution for something that I know already has a solution, but I don't have the knowledge to know how to search for the answer; so, I'm asking the community. If I were wanting to create a dropdown of all my questions in Power BI, that when you select one question, the visual also autopopulates, how would I do that? Whenever I choose a slicer, I can pick one question, but the options is what I can filter on, not the questions themselves. For example, let's say I have three questions I want to make a dropdown for with their associated visuals. Let's say the questions are: "How much do you agree with the following statement? - The school provides a safe environment.", "How much do you agree with the following statement? - I feel comfortable sharing my thoughts in class.", and "How much do you agree with the following statement? - I feel welcomed by my school's community." I don't want a dropdown of "Strongly agree to strongly disagree", which is all I'm getting with using the traditional slicer. I want a dropdown where someone can pick the question they're wanting to see and the visual will display for that question. Thank you!

[v-easonf-msft · Accepted solution]

Hi, @cspowerbi 

Please post some sample data in table form or pbix file.

This will help us better understand your current data model and the problem.

Best Regards,
Community Support Team _ Eason

[parry2k]

@cspowerbi I think I know where the problem is, your questions are part of the columns, not rows, or in other words, you have pivoted data and you need to unpivot it.

Transform Data -> Select columns (which are not question columns) ->Right Click -> Unpivot other columns

It will give you two new columns, called Attribute and Value, rename these columns as you see fit. 

Close and Apply

You can use the Attribute column as a slicer, which will have a drop-down of questions and you can visualize the data the way you want.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[amitchandak]

@cspowerbi , Not sure I got 100% what you need.

You can use interactions, and stop interaction between Question slicer -> and Question Visual

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

[cspowerbi]

Thank you all for your answers. I believe my issue was resolved. Thank you all for your comments!

[v-easonf-msft]

Hi, @cspowerbi 

It's pleasant that your problem has been solved.

Can you share your solution here and accept it as solution to close this thread?

So that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason