topic Re: Filter Type Relative Date - More Than in Developer

Filter Type Relative Date - More Than

mhgrace — Mon, 07 Jul 2025 14:39:44 GMT

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

Re: Filter Type Relative Date - More Than

Greg_Deckler — Mon, 07 Jul 2025 16:22:07 GMT

@mhgrace Interesting. Might submit that as an Idea. You can do that with measures. See the Complex Selector. The Complex Selector - Microsoft Fabric Community

Re: Filter Type Relative Date - More Than

v-karpurapud — Tue, 08 Jul 2025 05:15:45 GMT

Hi @mhgrace

Thank you for your feature suggestion. Adding a “More Than” option to the Relative Date filter would be helpful for cases where users need to filter data older than a specific date, like “More than 1 day ago” or “More than 1 year ago.” At present, Power BI’s relative date filter only includes “In the last,” “In this,” and “In the next” options, which can be limiting.

As @Greg_Deckler mentioned in the response, a current workaround is to use DAX measures or custom calculated columns to achieve similar results. The Complex Selector tool from the Microsoft Fabric Community can also help create more advanced filters with DAX. Still, having this feature built directly into the relative date filter would make it more accessible for all users.It is recommended to submit or upvote this idea on the Power BI Ideas Forum: https://ideas.powerbi.com

Regards,

Karpurapu D,

Microsoft Fabric Community Support Team.

Re: Filter Type Relative Date - More Than

mhgrace — Tue, 08 Jul 2025 07:58:59 GMT

hi @v-karpurapud thanks for your reply - I have added it as an idea as you suggested so will see if anything comes of it and will make a work around in DAX in the meantime.

Re: Filter Type Relative Date - More Than

mhgrace — Tue, 08 Jul 2025 08:00:51 GMT

Thanks for your reply @Greg_Deckler I've added it to the ideas bit now so will see what comes of it. I will investigate the complex selector in the meantime.

Re: Filter Type Relative Date - More Than

v-karpurapud — Tue, 08 Jul 2025 09:08:49 GMT

Hi @mhgrace

Thank you for the Update. . If you have found a solution with suggested workaround, please share it here, as it will help other community members facing similar issues. Looking forward to your response.

Re: Filter Type Relative Date - More Than

v-karpurapud — Mon, 14 Jul 2025 05:16:48 GMT

Hi @mhgrace,

I wanted to check if you had an opportunity to try the workaround in DAX or if your issue has been resolved. Could you please share an update?

Best Regards,

Karpurapu D.