Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Like this?
Yes this is how the data slicer currently is setted up but i need some additional filter to get the max version per ID which is not archived. Maybe an extra Measure for this FIlter ist needed on top of the data slicer which takes care about the date.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |