Hello Fabric Community,
I’m currently working on a Power BI report that involves a table (BAR) listing Application IDs, Submission Dates, and Completion Dates for the past 15 years (large dataset). Here’s an example of the data:
Application ID | Submission Date | Completion Date |
149 | 3/1/2021 | 3/15/2021 |
156 | 3/19/2021 | 4/1/2021 |
211 | 4/21/2021 | 4/28/2021 |
232 | 4/30/2021 | 5/16/2021 |
255 | 6/7/2021 | 7/15/2021 |
303 | 9/18/2021 | 10/1/2021 |
My query also includes a 'Calendar' table.
I’d like to create a slicer that allows users to filter by a time range (e.g., from 4/1/2021 to 4/30/2021) to display all Application IDs that were either submitted or completed in the selected time frame.
Desired Visual after applying the filter for 4/1/2021 to 4/30/2021:
Application ID | Submission Date | Completion Date |
156 | 3/19/2021 | 4/1/2021 |
211 | 4/21/2021 | 4/28/2021 |
232 | 4/30/2021 | 5/16/2021 |
I tried filtering after connecting the Calendar’s Dates to both BAR’s Submission and Completion dates but the results were not as expected:
Application ID | Submission Date | Completion Date |
211 | 4/21/2021 | 4/28/2021 |
232 | 4/30/2021 | 5/16/2021 |
If anyone has insights on how to achieve the desired outcome, I’d greatly appreciate it!
