Forum Discussion
Be
Advocate I
Advocate IMake a slicer a cascading dropdown?
Does anyone know if there is a way, with code or what have you, that will make a slicer a dropdown list (like a cascading dropdown list in excel)? Or have a small search box within the slicer for lis...
Phil_Seamark
Microsoft Employee
Microsoft EmployeeNice, thank you
Hello Be
According to what I've understood you would like to get cascading slicer, just like in Excel (selecting one will filter the other slicers)?
If it ok, this is a workaround while waiting for the eventuality of having a real one :
If you put slicers with columns belonging to the same table (assuming for example you have your dimension labelled in your fact table), the cascading is automatic :)
My example, display two slicer from columns belonging to the same table : slicer 1 display type of posts and slicer 2 display location of posts.
When I choose a type the location change to show the relevant data :
And if I choose a location slicer value, the type value is updated too :
But remember that the slicer should