Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |