Forum Discussion

Mkhan13's avatar
Mkhan13
New Member
2 years ago
Solved

Dynamic slicer

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? 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • wini_R's avatar
    wini_R
    2 years ago

    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.

1 Reply

  • wini_R's avatar
    wini_R
    Solution Supplier
    2 years ago

    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.