bar and column chart - add a field per column

[AgustinBrocardo]

Hi!

I´m have a database for a survey where i have one question per colmn. It 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 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.

[amitchandak · Accepted solution]

@AgustinBrocardo , Create a new table that has values from Question1 to Question5 in rows in question columns

then try a measure

Switch(max(Question[Question]) ,

"Question 1", Sum(Table[Question 1]) ,

"Question 2", Sum(Table[Question 2]) ,

"Question 3", Sum(Table[Question 3]) ,

"Question 4", Sum(Table[Question 4]) ,

"Question 5", Sum(Table[Question 5])

)

Then use question from the question table in visual and try

[AgustinBrocardo]

Hi @amitchandak I couldn´t make it work. There´s also a fact i didn´t mention and it may be important, the database will be updated every two months, it won´t be a one time report