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.
@Anonymous , 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.
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.