The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am working on a dataset where i have yes/no/na type questions along with other questions.
1. For Yes/No Question I am selecting unpivot by clicking on edit query and then it unpivots the selected columns ,from which i can very well make the graphs.
But in the same table others question counts gets disturbed,thats why i am not able to work on other question.
See,i Have only 20 rows with 300 different columns.
Now when i unpivot some of the columns it goes to around 400 rows which is correct.
And i can plot the graphs correctly.
But the problem is that original sheet contains only 20 rows and if i have to work on some other columns to create graphs/table then it is working on total 400 rows which is incorrect.https://file.io/vyA9R1Y3s15h
I have also attached sample data file
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
7 |