- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Single drop down slice for different bar chart visualization of each field
Hi everyone, I am new to power BI and I have been trying to figure out how to make single drop down slicer visualizing a bar chart for selected fields.
I would like to visualize each field below in a bar chart but using a single dropdown slicer only:
Example table:
What fences do you have? | Type of home do you live in? | Any security systems? |
No Response | Unit/Townhouse | No Response |
No Response | House | Yes |
Front fence, Side fence(s), Rear fence | Unit/Townhouse | Yes |
Side fence(s), Rear fence | Farm | Yes |
Side fence(s), Rear fence | House | No |
Example dropdown slicer:
Would appreciate any help. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @kat_pbi ,
I agree with @Greg_Deckler . Please try to UnPivot your columns.
In addition, if his reply helps, please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Icey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@kat_pbi So in general you are going to want everything to be unpivoted so that you wend up with a single column with your questions in it and another column with your answers. I don't see the full dataset so hard to tell you exact steps in Power Query. Alternatively you could have a disconnected table with your questions in it but that is going to make the calculations far more difficult.
So like:
ResponseID,QuestionID,QuestionText,Score
1,Question1,This is a question,10
1,Question2,This is another question,3
2,Question1,This is a question,10
2,Question2,This is another question,3
3,Question1,This is a question,10
3,Question2,This is another question,3
You do NOT want:
ResponseID,Question1Text,Question1Score,QuestionIDText,Question2Score,Question3Text,Question3Score...
Not sure how much more specific I can be given the information. @ me in replies.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Greg_Deckler i wanted to visualize barcharts from different columns but using one drop down slicer only to interchange the barcharts. Is it still the same process?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-10-2024 06:37 AM | |||
10-25-2024 09:38 PM | |||
08-14-2024 05:22 AM | |||
09-11-2024 01:00 AM | |||
07-14-2024 08:08 PM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |