cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
geoffgarcia
Frequent Visitor

Vizualizing vendor responses to requirements for a selection process

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

DataData

 

 

 

Desired visualization (something like this)

GoalGoal

1 ACCEPTED SOLUTION
kentyler
Solution Sage
Solution Sage

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





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

3 REPLIES 3
kentyler
Solution Sage
Solution Sage

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





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

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.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!