Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |