Dynamic slicer

[Mkhan13]

Hi I have a problem with creating a dynamic slicer. 

I am creating a report which has 3 columns which are questions and the response values are Yes/No/Prefer not to say 

I need a slicer which has those responses to filter the correct total for each question. 

I have created a table with the responses to link it to the dataset however, if it is connected to one column it only calculates the correct total for that column and not the others. 

I've also tried to add all the questions to one slicer but that doesn't work either 

Any idea what can be done? 

[wini_R · Accepted solution]

Hi @Mkhan13 ,

I suppose you need to unpivot your table but to avoid guessing it would be helpful if you could send a screen shot of your data or table that you created.