Forum Discussion
Solved
Displaying likert scale in Power BI
Hi, new to Power BI. I am able to get the Qualtrics survey data into Power BI and graphs working well for the standard likert scale:
- Strongly disagree
- Disagree
- Neither
- Agree
- Strongly agree
However, I need to amalgamate the likert score to:
- Disagree or strongly disagree
- Neither
- Agree or strongly agree
Any advice?
Thank you.
Best regards
Hi John_Reid
You can do it in Power Query or using DAX.
In Power Query you can add a conditional column (*change Answer by your column name)
Table.AddColumn(#"Added Conditional Column", "Custom", each if [Answer]="Strongly disagree" or [Answer]="Disagree" then "Disagree or strongly disagree" else if [Answer]="Strongly agree" or [Answer]="Agree" then "Agree or strongly agree" else if [Answer]= "Neither" then "Neither" else null)DAX
Calculated column = IF ([Answer]="Strongly disagree" || [Answer]="Disagree", "Disagree or strongly disagree", IF ([Answer]="Strongly agree" ||[Answer]="Agree", "Agree or strongly agree", IF ([Answer]= "Neither", "Neither", null)))Thank you very much!
3 Replies
Thank you very much!
mlsx4Memorable Member
Hi John_Reid
You can do it in Power Query or using DAX.
In Power Query you can add a conditional column (*change Answer by your column name)
Table.AddColumn(#"Added Conditional Column", "Custom", each if [Answer]="Strongly disagree" or [Answer]="Disagree" then "Disagree or strongly disagree" else if [Answer]="Strongly agree" or [Answer]="Agree" then "Agree or strongly agree" else if [Answer]= "Neither" then "Neither" else null)DAX
Calculated column = IF ([Answer]="Strongly disagree" || [Answer]="Disagree", "Disagree or strongly disagree", IF ([Answer]="Strongly agree" ||[Answer]="Agree", "Agree or strongly agree", IF ([Answer]= "Neither", "Neither", null)))