I have this table with the form:
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
Go to Solution.
@varunkale , what are these 1,2,...6
You should unpivot this columns in power query
https://radacad.com/pivot-and-unpivot-with-power-biUnpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11
View solution in original post
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.
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!