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,
I'm trying to make a graph from SharePoint data. In these SharePoint data there are answers to certain questions that look like this: Strongly Disagree, Disagree, Neutral, Agree, Strongly Agree. For lay-out reasons I cannot change these answers to values within SharePoint. For my graph however I would like to be able to calculate average values to each question. So StronglyDisagree should equal 1, Disagree 2,... What function will let me do this?
Thank you in advance.
Kind regards,
Matthias
Solved! Go to Solution.
hello @Matthias93
You can do it with a conditional column:
Go to Edit Query--Add Column - Conditional Column
Select each Value (Agree,Disagree, etc) and put the Numeric Value that you assign.
How would you plot those on a chart? Say you want the parameters (Strongly Agree, Agree, Neutral, etc) on the Y-axis and the count on the X-axis. How do you plot it such that the parameter names are used as the Y-axis labels? I have a very similar problem in that my string values can't be used as axis labels.
Edit:
After pivoting my columns for the questions. My data now looks like this
hello @Matthias93
You can do it with a conditional column:
Go to Edit Query--Add Column - Conditional Column
Select each Value (Agree,Disagree, etc) and put the Numeric Value that you assign.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |