How to display a table to use in PowerBI

[varunkale]

I have this table with the form:

Question	1	2	3	4	5	6
Q1	3	4	2	5	2	1
Q2	3	4	1	5	1	1
Q3	4	2	1	5	2	5

its got the questions as row 1 and the response counts as column names.

What is the best way to diplay this table so that I can use it in my PowerBI Dashboard

[Dhacd]

Hi, This is in a pivoted format. 
You can use the unpivot feature in the Power Query and then have a total of 3 columns in the table with a hierarchical structure.

Regards,

Atma.

[amitchandak · Accepted solution]

@varunkale , what are these 1,2,...6

You should unpivot this columns in power query

https://radacad.com/pivot-and-unpivot-with-power-bi
Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11