Hi, i am from Perú. You don't know how i suffered for a guide for build a graph and analyze a multiple choice survey data. No info in spanish, no info in Power BI community. Just you had the answer and finally i finished. Your video is gold and you need to put a guide for step by step that pivot and procedures that are very complex but useful in analizing multiple choice questions. Sound is not good, however the content is a gem. Thank you :) New Suscriber.
Thank you - it was doing my head in how to create the data model, which is the key to this problem. Great simple steps. You're very kind - thanks so much!
This is really cool stuff! Question, if I want to create measures that show the % of individuals who use each program what is the best way to go about doing that? Additionally, if I want to add slicers, for example a slicer for each department they work in what is the best way to go about doing that while still showing the aforementioned percentage measures correctly? Thank you for posting this, really helpful stuff.
The video is excellent. Help me start breaking apart my survey, but I hit a snag. I am hoping someone can give me advice. The survey has 62 questions and 5 possible responses. I did separate columns, like gender, to another table using the index option shown in the video. However, with the questions, I would like to group them by category and perform calculations. For example, questions 1-8 are about Job Satisfaction and questions 9-14 are about Compensation. So I might want a break down of Female Hispanics. Any advice?
Hi! Great video. My forms is addign a semi-colon to the final word, so PowerBI creates an additional empty "value" next to the indexes. I see that you have no special characters at the end of your multiple choice answers. Wondering if anyone had a solution so I could strip it out automatically/prevent the emptry row being made? (yours says "Word, Excel" whilemine says "Word;Excel;" for instance)
Hi, thanks for the video. Have a question. Do you know how to automate these steps with scripts to do not repeat manually for each column? Let's think we have a list of target columns.
Hi, thank you for your video, it's really useful. I just have one more question, is it possible to create the same visualizations of programs and motivators for percentage of employees, not number? Thank you!
@@carltonseymour869 You can try it yourself, it will not work because of the filters we are taking from the other tables, and to filter that main table (where we create the countrows measure), the filter should be bidirectional. Of course, there are other advanced ways to create measures, but this approach is the easiest one.