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])
Indeed, as you are using the same column, you cannot use the SelectedValue formula, which returns the selected value in the column.
One workaround would be to create a calculated column for your value (it's just a duplicate of your date column), which would allow you to use one column for each slicer. In this case, the SelectedValue would return the correct value for each.
After that, you can create a measure like this one:
Slicers Selection = SELECTEDVALUE('Table'[Date]) & " - "&SELECTEDVALUE('Table'[DupplicateDate]) ...
Thank you for your suggested workaround. A calculated column is definitely an easier workaround for me than a whole new table. Gonna try it now!
