Forum Discussion
Solved
Data Slicing on two specific Dates
Hello everyone, I wanna select two specific dates in my data slicers (e.g. 03.01.2022 and 30.12.2022) and only show/select the data on those two dates. The first data slicer should select the f...
Hello NiemansYolo,
Can you please try this:
1. Set Up Two Date Slicers (Set both slicers to use the date field from your data)
2. Create Two Measures to Capture the Slicer Values
Selected Date 1 = MIN('YourTable'[DateField])Selected Date 2 = MAX('YourTable'[DateField])3. Filter Your Data Based on the Slicer Selections
Date Filter = VAR Date1 = [Selected Date 1] VAR Date2 = [Selected Date 2] RETURN IF( SELECTEDVALUE('YourTable'[DateField]) = Date1 || SELECTEDVALUE('YourTable'[DateField]) = Date2, 1, BLANK() )Should you require any further assistance, please do not hesitate to reach out to me.
Sahir_Maharaj
Super User
Super UserHello NiemansYolo,
Can you please try this:
1. Set Up Two Date Slicers (Set both slicers to use the date field from your data)
2. Create Two Measures to Capture the Slicer Values
Selected Date 1 = MIN('YourTable'[DateField])Selected Date 2 = MAX('YourTable'[DateField])3. Filter Your Data Based on the Slicer Selections
Date Filter =
VAR Date1 = [Selected Date 1]
VAR Date2 = [Selected Date 2]
RETURN
IF(
SELECTEDVALUE('YourTable'[DateField]) = Date1 ||
SELECTEDVALUE('YourTable'[DateField]) = Date2,
1,
BLANK()
)Should you require any further assistance, please do not hesitate to reach out to me.