Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Experts,
I want to visualize the data from an online survey. The row data collected from the survey is in the format as below. There are three multiple choice questions.
Recruiter | Question 1 | Question 2 | Question 3 |
A | Highly Satisfactory | Unsatisfactory | Satisfactory |
B | Highly Satisfactory | Partially satisfactory | Satisfactory |
C | Beyond Satisfactory | Satisfactory | Unsatisfactory |
I wish to create a visualization to show the overall count. Is it possible to create a new table and convert the data into the following format?
Answers | Question | Recruiter |
Highly Satisfactory | 1 | A |
Highly Satisfactory | 1 | B |
Beyond Satisfactory | 1 | C |
Unsatisfactory | 2 | A |
Partially satisfactory | 2 | B |
Satisfactory | 2 | C |
Satisfactory | 3 | A |
Satisfactory | 3 | B |
Unsatisfactory | 3 | C |
Many thanks!
Solved! Go to Solution.
Hi @TomLU123,
You can create new table using below DAX Formula for getting the desired results.
New Recruiter = union(SELECTCOLUMNS(Recruiter,"Answer",Recruiter[Question 1],"Question",1,"Recruiter",Recruiter[Recruiter]), SELECTCOLUMNS(Recruiter,"Answer",Recruiter[Question 2],"Question",2,"Recruiter",Recruiter[Recruiter] ), SELECTCOLUMNS(Recruiter,"Answer",Recruiter[Question 3],"Question",3,"Recruiter",Recruiter[Recruiter] ))
Thanks,
Rahul
Hi @TomLU123,
You can create new table using below DAX Formula for getting the desired results.
New Recruiter = union(SELECTCOLUMNS(Recruiter,"Answer",Recruiter[Question 1],"Question",1,"Recruiter",Recruiter[Recruiter]), SELECTCOLUMNS(Recruiter,"Answer",Recruiter[Question 2],"Question",2,"Recruiter",Recruiter[Recruiter] ), SELECTCOLUMNS(Recruiter,"Answer",Recruiter[Question 3],"Question",3,"Recruiter",Recruiter[Recruiter] ))
Thanks,
Rahul
User | Count |
---|---|
73 | |
72 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
51 | |
43 | |
42 |