Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community..!!
Please refer the above image.
above is my dataset, I want a output like, after selecting questions i want a perticular country name.
select any question and we should get to know in which countries that question has been asked.
Thanks in advance..!!
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
My guess is that your dataset has one column for each question. If that is correct, then you need to select all columns other then the Question columns, right click and select "Unpivot Other Columns". Now build your visual.
Hi @Ashish_Mathur
It does not solve my problem, if I follow your inputs , as shown in the below image
i did unpivoting of column coutry.
Hi,
Share the link from where i can download your PBI file.
Hi,
Share data in a format that i can paste in an MS Excel file.
Hi @Ashish_Mathur
please find the below data
country name | Question1 | Question2 | Question3 | Question4 |
India | 5 | 4 | 3 | 4 |
UAE | 4 | 5 | 4 | 3 |
USA | 3 | 3 | 5 | 5 |
Canada | 5 | 2 | 3 | 2 |
Japan | 4 | 4 | 4 | 4 |
England | 3 | 3 | 2 | 5 |
Hi,
You may download my PBI file from here.
Hope this helps.
You can take similar data as shown in the above pic.
I have also inserted that manually.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |