I have a 1000 row dataset from survey monkey. There are 6 columns of data (Col1,Col,...,Col6). The value in each row across all columns is a number, 1 - 6.
I'm new to Power BI so what I'm struggling with is how to create the row labels in my output table.
Thanks in advance,
Go to Solution.
You can easily do it in QUERY EDITOR with a series of unpivoting, GROUPING and Pivoting back
See the atatched file here
Select All Columns and unpivot them
Step # 2
Group by VALUE and ATTRIBUTE and aggreagate by COUNTROWS
Pivot the attribute Column using Count column as Values
Is that really what you're looking for?
@Zubair_Muhammad you've just opened a door in my Power Query knowledge. Thanks for the great set of instructions and the sample file, much appreciated.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.