Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
mhgrace
New Member

Filter Type Relative Date - More Than

 

It would be great if Power BI could add a More Than option to the relative date filter so that you could filter for dates that are More Than e.g. 1 day/week/year ago

 

The options currently are only In the last, In this and In the next 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @mhgrace,

Thanks for reaching out to the Microsoft fabric community forum.

You are right that the current Relative Date filter options in Power BI are limited to "In the last", "In this", and "In the next", and there’s no direct UI option for "More Than".

However, you can achieve this behavior using a workaround with a custom column and a standard filter. If you want to go through the workarounds then I can help you with that.

 

I would also take a moment to thank @MasonMA, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @mhgrace,

Thanks for reaching out to the Microsoft fabric community forum.

You are right that the current Relative Date filter options in Power BI are limited to "In the last", "In this", and "In the next", and there’s no direct UI option for "More Than".

However, you can achieve this behavior using a workaround with a custom column and a standard filter. If you want to go through the workarounds then I can help you with that.

 

I would also take a moment to thank @MasonMA, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

Anonymous
Not applicable

Hi @mhgrace,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well.

And if you're still looking for guidance, feel free to give us an update, we’re here for you.

 

Best Regards,
Hammad.

Anonymous
Not applicable

Hi @mhgrace,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.

 

Best Regards,

Hammad.

Anonymous
Not applicable

Hi @mhgrace,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.

 

Best Regards,

Hammad.

MasonMA
Super User
Super User

There are workarounds but you are right and i'll vote for this! 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.