Filter country name after selecting question

[ppatil]

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..!!

[Ashish_Mathur]

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.

[ppatil]

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.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[ppatil]

Hi @Ashish_Mathur 

Is that possible?

[Ashish_Mathur]

Hi,

Share data in a format that i can paste in an MS Excel file.

[ppatil]

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[ppatil]

Hi @Ashish_Mathur 

You can take similar data as shown in the above pic.

I have also inserted that manually.