Creating two slicers

Question

Hi everyone,&nbsp;&nbsp;I have a problem hoping to get some advice from you all. I have a project collecting data from two states and I am hoping to create two slicers to display their data. The first slicer will be filtering states, and the second slicers will be filtering counties within the selected state.&nbsp;&nbsp;My imagination is when someone select a state from the first slicer, they can then select which county(counties) of data they are interested in looking at.&nbsp;&nbsp;I have a table for two states' state name and one table listing all the counties in both states (in one column)&nbsp;&nbsp;Should I made one column for each state and list the counties within one state (two columns in total instead)? How can I connect these two filters to do what I hope to see?&nbsp;&nbsp;Really appreciate your help!!&nbsp;&nbsp;Thank you,Emily

lbendlin · Accepted Answer

Don't connect anything.&nbsp; Have two disconnected tables, each feeding its own slicer.&nbsp; Note that slicers support field hierarchies.&nbsp; So your tables can contain two columns, state and county. Then use measures to react to the slicer selections.

Forum Discussion

Creating two slicers

2 Replies

Related content

Creating date slicer removes data

Creating a dynamic slicer

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Create Slicer

Creating relationships