Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Resolver I

## One table, 2 date slicers that work as an "or" not "and"

I have two date slicers, Create Date and Close Date. Both are used as relative date slicers and will select a date range. I have one table that just returns a bunch of item detail data, no aggregations. I need the slicers to filter the table as an "or" condition, rather than "and".

If I select Create Date in Last 1 week and Close Date in Next 1 week, I should see all records that either have a Create Date in the last week OR a Close Date in the next week.  Since the slicers can return multiple values, I think I need to use "ALLSELECTED" function, but I am having trouble figuring out how to use it in a measure to filter the table with since I am not calculating any aggregations. Anyone have ideas?

1 ACCEPTED SOLUTION
Community Support

Create two another identical tables.

``date 2 = ALLSELECTED('date'[date])``

Apply two tables of date for two slicer respectively.

Then create a measure.

``slicer_date = IF(SELECTEDVALUE('date'[date]) in VALUES('date 1'[date]) || SELECTEDVALUE('date'[date]) in VALUES('date 2'[date]),1,0)``

Finally, put the measure on the data filter.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly

3 REPLIES 3
Community Support

Create two another identical tables.

``date 2 = ALLSELECTED('date'[date])``

Apply two tables of date for two slicer respectively.

Then create a measure.

``slicer_date = IF(SELECTEDVALUE('date'[date]) in VALUES('date 1'[date]) || SELECTEDVALUE('date'[date]) in VALUES('date 2'[date]),1,0)``

Finally, put the measure on the data filter.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly

Super User

@smileamile2 , As long as all other columns other than the measure you created are un summarized, measure will filter the table

With independent date table

example

measure =
VAR _max = MAXX(allselected('Date1'),'Date1' [Date])
return
countrows(filter(Table, Table[Create Date] >=_max-7 && [Create Date] <= _max && Table[close Date] >=_max && [Close Date] <= _max +7 ))

use this measure with all other fields as un summarized in visual.

Or filter this value is not blank in the visual level filter

Resolver I

Well, I can't have the +-7 in the measure itself. I have relative date slicers that allow user to select any date range that can change

## Helpful resources

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

#### Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors