Forum Discussion

Frequent Visitor

3 years ago

Solved

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 ...

Need Help

Anonymous
3 years ago
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
One Filter for two attributes.pbix24 KB

Anonymous

Not applicable

3 years ago

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

One Filter for two attributes.pbix24 KB