Reply
disney_batista
Frequent Visitor

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?

Captura de tela 2025-03-17 202546.pngCaptura de tela 2025-03-17 202553.png

2 REPLIES 2
lbendlin
Super User
Super User

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?

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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)