Forum Discussion
Bar chart with several fields
- 4 years ago
You may try this workaround. First, you need a column containing your questions. Then you can create a Measure like this:
QuestionAvg =
SWITCH(
SELECTEDVALUE(QuestionList[Question]),
"Question1",AVERAGE('Table'[Question1]),
"Question2",AVERAGE('Table'[Question2]),
"Question3",AVERAGE('Table'[Question3]),
"Question4",AVERAGE('Table'[Question4]),
"Question5",AVERAGE('Table'[Question5])
)
The result looks like this:
Also, attached the pbix file as reference.
Best Regards,
Community Support Team _ Caiyun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it, please feel free to let us know. Thanks a lot!
You may try this workaround. First, you need a column containing your questions. Then you can create a Measure like this:
QuestionAvg =
SWITCH(
SELECTEDVALUE(QuestionList[Question]),
"Question1",AVERAGE('Table'[Question1]),
"Question2",AVERAGE('Table'[Question2]),
"Question3",AVERAGE('Table'[Question3]),
"Question4",AVERAGE('Table'[Question4]),
"Question5",AVERAGE('Table'[Question5])
)
The result looks like this:
Also, attached the pbix file as reference.
Best Regards,
Community Support Team _ Caiyun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it, please feel free to let us know. Thanks a lot!
- AgustinBrocardo4 years agoFrequent Visitor
Thanks! it worked perfectly!
- v-cazheng-msft4 years agoCommunity Support
That's great! Thanks for your feedback!
Best Regards,
Community Support Team _ Caiyun