Hello PowerBI community!
I'm trying to implement smart filtering in PowerBI visuals. Initially, I've been using a date slicer to show data prior to the selected date. However, this method is not fully meeting my requirements.
Here's an example to illustrate the desired filtering behavior:
Input Table:
| ID | Version | Date | IsArchived | Other columns... |
| 245 | 1 | 01/15/2023 | false | ... |
| 245 | 1 | 03/31/2023 | true | ... |
| 245 | 1 | 04/15/2023 | false | ... |
| 256 | 1 | 01/19/2023 | false | ... |
| 256 | 2 | 02/26/2023 | false | ... |
| 256 | 3 | 03/23/2023 | false | ... |
| 879 | 1 | 12/01/2023 | false | ... |
| 879 | 2 | 01/15/2023 | false | ... |
| 879 | 3 | 02/23/2023 | false | ... |
When I select the date 02/12/2023 from the date picker, the table should filter as:
| ID | Version | Date | IsArchived | Other columns... |
| 245 | 1 | 01/15/2023 | false | ... |
| 256 | 1 | 01/19/2023 | false | ... |
| 879 | 2 | 01/15/2023 | false | ... |
When I then select the date 04/01/2023, the table should filter as:
| ID | Version | Date | IsArchived | Other columns... |
| 245 | 1 | 01/15/2023 | false | ... |
| 256 | 3 | 03/23/2023 | false | ... |
| 879 | 3 | 02/23/2023 | false | ... |
The aim is to always display the versions relative to the selecteddate, excluding the archived entries. How can I create such a dynamic filter to refine my dashboard and its visuals based on this logic in PowerBI Web?
Thank you in advance for your insights and advice!
