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 Ho...
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!
