Forum Discussion

StrangeClimate's avatar
StrangeClimate
New Member
1 year ago
Solved

Filter Separate Start and End Date Columns with One Filter

Hello,

 

I am currently building a power bi dashboard off of my organization's scheduling software to see who is using our services and when over a given time. 

 

Each line of data represents an event that has a separate start date and an end date column that I have linked to a date table. 

 

On my dashboard I have created a matrix to display columns for organization, start date, end date, and number of people that is filtered by selecting a date range. 

 

The problem is if I select 1/1/25 and 1/31/25 the filter will cut out events that have a start date of 12/30/24 and an end date of 01/5/25 or a start date of 1/15/25 and end date of 02/04/2025.

 

How can I show PowerBi that events that have start or end dates outside of the selected filter but occurr during the selected time range are continuous and should be displayed?

 

Thanks!

 

 

Need Help

4 Replies

  • StrangeClimate's avatar
    StrangeClimate
    New Member
    1 year ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.