Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello again,
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,
Mark
Solved! Go to Solution.
Hi @67nmark
You can easily do it in QUERY EDITOR with a series of unpivoting, GROUPING and Pivoting back
Step#1
Select All Columns and unpivot them
Step # 2
Group by VALUE and ATTRIBUTE and aggreagate by COUNTROWS
Step 3
Pivot the attribute Column using Count column as Values
Hi @67nmark
You can easily do it in QUERY EDITOR with a series of unpivoting, GROUPING and Pivoting back
Step#1
Select All Columns and unpivot them
Step # 2
Group by VALUE and ATTRIBUTE and aggreagate by COUNTROWS
Step 3
Pivot the attribute Column using Count column as Values
@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.
Cheers,
Mark
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |