Forum Discussion
josegovia
9 years agoRegular Visitor
Values in rows. Clustered bar chart
Hello
I want to add several variables to a bar chart. The variables contain values that are between 0 and 10, and I want the chart show the mean of each variable.
The label of each bar must be the name of the variable or a custom value, and the value must be the average of the values of that varibale.
For example, I have two variables, satisfaction and knowledge, with 300 cases each. And the values they contain are between 0 and 10.
I need a chart that contains two bars, with the mean of each variable and the labels of the bars being the variable title or a custom text.
Can it be done?
Thank you.
1 Reply
- v-chuncz-msft
Community Support
Yes, you may add two measures and then drag them to Value.
mean of satisfaction = AVERAGE ( Table1[satisfaction] )
mean of knowledge = AVERAGE ( Table1[knowledge] )