Forum Discussion
Filter Separate Start and End Date Columns with One Filter
Hi,
You will need to use a disconnected dates table for that and create a measure that considers what dates are within the ranges. Please see the attached sample pbix.
I was able to use the disconnected table to successfully filter the dates in a table. However the visuals I built off the filtered data do not filter successfully. I have tried to add the same filter parameters without success. Thanks for the continued help.
Hi StrangeClimate ,
As far as I know, this workaround that filtering visual by measure in visual level filter would work only you disconnect or inactive the relationship between the Calendar table and Fact data table.
If the relationship is active, your visual will be filtered by relationship first, it will remove the data out of the slicer range.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.