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.
I have a survey question:
Which of these did you do:
A) I did A
B) I did B
C) I did C
which results in a table:
I did A | I did B | I did C |
TRUE | TRUE | |
TRUE | TRUE | |
TRUE | TRUE | |
TRUE | TRUE |
How could I turn this into a bar chart?
Solved! Go to Solution.
Another way is:
Step 1
Go to Edit Queries
Select your columns with answers.
Transform - Unpivot Columns
Step 2
In the bar chart put Attribute (You can change the name to Question or another) in axis and Values(You can change the name to answer or another) in Value section
Ah, that is not how I thought to do that. Thanks! How would I get a legend in there? All I have in the legend now is "Count of Q1_A", "Count of Q1_B","Count of Q1_C"
you need to create a measure for each column:
A = CALCULATE(COUNTROWS(Survey),Survey[I did A]=True)
B = CALCULATE(COUNTROWS(Survey),Survey[I did B]=True)
C = CALCULATE(COUNTROWS(Survey),Survey[I did C]=True)
Is there no other easier/alternative way to do things? I"ve got like 40 survey questions like this.
Another way is:
Step 1
Go to Edit Queries
Select your columns with answers.
Transform - Unpivot Columns
Step 2
In the bar chart put Attribute (You can change the name to Question or another) in axis and Values(You can change the name to answer or another) in Value section
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 |