Forum Discussion
One Filter for two attributes
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
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 _filterAdd this measure to the visual level filter and set it as follows.
Best Regards,
Gao
Community Support TeamIf 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
2 Replies
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 _filterAdd this measure to the visual level filter and set it as follows.
Best Regards,
Gao
Community Support TeamIf 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
Anonymous
That's works perfectly. Many thanks to you!
