Convert the survey Data in to visualization

[TomLU123]

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!

[RahulYadav · Accepted 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