- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Custom Date Period Selections
Hello everyone,
I'm using a custom date filtering solution, based on this post: https://bielite.com/blog/custom-date-period-power-bi/
In short, I have two date filters:
1- With predefined periods (current month, previous month, year-to-date, etc.)
2- With custom selection
Filter 2 is only enabled when the "Custom" option is selected in filter 1. When clicking on the other predefined options, filter 2 is disabled (more details in the link mentioned above).
I would like to know if there is any way to block the other predefined period buttons when clicking on "Custom", and re-enable them when clicking on a button or activating a function. Is this possible?
Has anyone ever come across something similar?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is your goal? Do you want to streamline the user experience so there are fewer clicks between the users and the insights, or do you want to spend time and energy on treating them like toddlers and telling them what they can and cannot do?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In this case, I need a block, since filter 2 (customizable) limits the date range when used, interfering with the correct action of the predefined buttons.
e.g.: if I filter a period equivalent to the previous year in filter 2, the "Last month" button in filter 1 (predefined) does not work, the last month is outside the range already filtered from the previous year.
What I'm looking for is a way to reset the customizable filter so I can go back to using the predefined filter.
If you are a master in user experience, please indicate the best way to deal with this case or another solution for using a date filter combining predefined and customized periods.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-09-2024 08:59 AM | |||
10-09-2024 06:29 AM | |||
07-10-2024 04:46 AM | |||
09-15-2024 08:24 PM | |||
09-24-2024 01:36 PM |
User | Count |
---|---|
15 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
17 | |
6 | |
3 | |
2 | |
2 |