Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |