March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi!
I´m have a database for a survey where i have one question per colmn. It is refreshed every two months and this part of the database looks like this:
Customers,Question1,Quesiton2,Question3,Question4,Question5
Customer1,3,3,3,3,3
Customer2,4,4,3,4,3
Customer3,5,3,4,2,4
The answers are numbers from 1 to 5 and i want to make a bar/column chart where each column of the char represents the average answer for each question.
In power bi, without editing the imported data, i have one field for each column:
Is there a way to add each question as a separate column in the bar chart?
The solution i found is unpivoting the question columns but it´s a problem because i need to use the individual questions for other visuals and analysis. In reality i have around 70 questions (70 columns) and i need to do this same process with other groups of questions, unpivoting is not an option because if i do it for every group, the power query model becomes too big.
Solved! Go to Solution.
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!
Thanks! it worked perfectly!
That's great! Thanks for your feedback!
Best Regards,
Community Support Team _ Caiyun
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
15 | |
12 | |
9 | |
8 |
User | Count |
---|---|
41 | |
32 | |
29 | |
12 | |
12 |