Need to filter data on when a row was active

Hi RichardBroadley,

If I understand correctly, you won't have much luck finding/using custom visuals to solve this, as they are bound by the same rules as the data model in terms of filtering, as you have discovered.

If you want to filter based on effective/end date ranges, the simplest implementation will be to create a measure that flags your record if its date range matches the selected date in a regular slicer, and then filter by that in any visuals. Note that this technique requires using 1/0 int values rather than TRUE/FALSE, as for some reason boolean measures can't be used as filter values in visuals, but numeric values can.

I believe this post should give you the concept of what you need, the answer marked as the solution covers the final state, but start reading from this post in the thread.

Hopefully this should be all you need. If not, if you can provide some sample data or workbook we can take a stab at it.

Regards,

Daniel