Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm new to Power BI, so apologies for such a simple question.
We are doing a vendor evaluation and my data set includes the ID, question, and each vendors response (screenshot below). I'd like to be able to visualize the counts of each response (out of the box, customizable, not possible, etc.) by vendor but can't quite figure out how to get there.
I've created a measure that allows me to count the # of OOTB for Vendor A, but doing this for all responses and vendors doesn't seem like the right solution.
I've tried to put the responses in another table and link them to do a count but I'm not sure how to link the table to the multiple columns in my response table.
Any guidance would be very much appreciated.
Thanks,
Geoff
Data
Data
Desired visualization (something like this)
Goal
Solved! Go to Solution.
You will need to unpivot your data, so you have a column for "Vendor Type", instead of a column for vendor a and a column for vendor b.
You should probably make a reference copy of your table and reduce it to non duplicate values of the responses, and create a relationship back to your fact table.
If you do that you should be able to generate the graph you want by dragging the appropriate fields on a graph visual.
Join the conversation at WeTalkBi.com
Learn more at SlowBI.com
Help when you know. Ask when you don't!
You will need to unpivot your data, so you have a column for "Vendor Type", instead of a column for vendor a and a column for vendor b.
You should probably make a reference copy of your table and reduce it to non duplicate values of the responses, and create a relationship back to your fact table.
If you do that you should be able to generate the graph you want by dragging the appropriate fields on a graph visual.
Join the conversation at WeTalkBi.com
Learn more at SlowBI.com
Help when you know. Ask when you don't!
Thanks Ken, I follwed all of your advice and it works as I had hoped.
Thank you so much for such a fast and clear response.
Glad to hear it. Always feel free to get in touch.
Help when you know. Ask when you don't!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
73 | |
54 | |
43 | |
37 |
User | Count |
---|---|
98 | |
64 | |
54 | |
48 | |
45 |