One Filter for two attributes

[wvuthha]

Hi Community,

I have a table with from- and to-dates in two different columns. I want to filter that with one filter. Best would be a slider where I have the left circle for "from" and the right for "to". Is this possible somehow?

Example

Article	Price	from	to
Car	30000	01.01.2022	31.03.2022
Car	35000	01.04.2022	31.12.2022

With the slider I want to get the price which was relevant between 10.02.2022 and 25.02.2022.

Is this possible?

Best regards

Thomas

[Anonymous · Accepted solution]

Hi @wvuthha，

You need a calendar table and a measure:

Measure = 
VAR _slicer_min = MIN('Calendar'[Date])
VAR _slicer_max = MAX('Calendar'[Date])
VAR _from_date = MAX('Table'[from])
VAR _to_date = MAX('Table'[to])
VAR _filter = IF(_slicer_min<=_from_date&&_slicer_max>=_to_date,1)
RETURN
_filter

Add this measure to the visual level filter and set it as follows.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[wvuthha]

@Anonymous 

That's works perfectly. Many thanks to you!