Forum Discussion
Create dashboard with many duplicate collumns
Hi All,
I have a set of data that is formed from 5 sheets. Within those 5 sheets there are multiple questions which are identical. They are for different types of vehicles but the same question needs to be asked across the different vehicles so the same collumns are created in Power BI. How do i go about displaying this data in a dashbaord. I have attached a snippet of the table view where a couple of rows have been inputted to test the microsoft form of which it has been populated from. I have also shows a snip of the data collumns too. As you can see duplicate questions but they are asked for the different types of vehicles e.e electric, combustion. I have a feeling i need to "bucket" the data but not sure where to start! Help haha.
On the Query Editor select all columns that are questions then on the transform select unpivot:
5 Replies
- MFelix
Super User
Hi Anonymous ,
The best option in this case is to select the columns with the questions and do Unpivot columns, this will give you a table with all the information about the vehicles and then two other columns attribute (question) and the value (answer) then you can do all type of visualizations you need by selecting the specific question.
- MFelix
There is no need because you have that information in the questionaire you just need to unpivot the columns,
- MFelix
On the Query Editor select all columns that are questions then on the transform select unpivot: