Forum Discussion
Duplicate Slicer Question
Slicers filter the entire data model, so you can't get independent selections from two slicers on the same column.
The workaround: Create a separate disconnected table for your second frequency (Annual/Quarterly/Monthly). Use that table for your second slicer, then use SELECTEDVALUE on that disconnected table in your measure.
SlicerA_Selection = SELECTEDVALUE('FrequencyTable'[Frequency])
SlicerB_Selection = SELECTEDVALUE('DisconnectedFrequencyTable'[Frequency])
Slicers filter the entire data model, so you can't get independent selections from two slicers on the same column.
The workaround: Create a separate disconnected table for your second frequency (Annual/Quarterly/Monthly). Use that table for your second slicer, then use SELECTEDVALUE on that disconnected table in your measure.
SlicerA_Selection = SELECTEDVALUE('FrequencyTable'[Frequency])
SlicerB_Selection = SELECTEDVALUE('DisconnectedFrequencyTable'[Frequency])
Thank you so much for your quick reply. I had a feeling that I would have to expand my Data Model which I was hoping to avoid. Ah well.