Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
AgustinBrocardo
Frequent Visitor

Bar chart with several fields

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: 

AgustinBrocardo_0-1635960577356.png

 

 

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.

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @AgustinBrocardo 

 

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:

vcazhengmsft_0-1636098472097.png

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!

 

View solution in original post

3 REPLIES 3
v-cazheng-msft
Community Support
Community Support

Hi @AgustinBrocardo 

 

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:

vcazhengmsft_0-1636098472097.png

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!

Hi @AgustinBrocardo 

 

That's great! Thanks for your feedback!

 

Best Regards,

Community Support Team _ Caiyun

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.