topic Re: Dynamic Filter in DAX Commands and Tips

Dynamic Filter

benford888 — Mon, 21 Jul 2025 23:59:59 GMT

I want to measure that allows a visual to show the last 13 months of data if the data is not filtered.

But filter to the defined daterange if a date range or finacial year is selected

Re: Dynamic Filter

Greg_Deckler — Tue, 22 Jul 2025 00:59:40 GMT

benford888 Try using a Complex Selector: The Complex Selector - Microsoft Fabric Community

Re: Dynamic Filter

benford888 — Tue, 22 Jul 2025 01:06:41 GMT

I'll give it a go. thanks Greg

Re: Dynamic Filter

v-priyankata — Fri, 25 Jul 2025 08:37:26 GMT

Hi benford888

Thank you for reaching out to the Microsoft Fabric Forum Community.
Greg_Deckler Thanks for the inputs.

benford888 - I hope you had a chance to try the suggestion from the user. Has the issue been resolved? If you encounter any further problems, please reach out to the community for assistance.

Thanks.

Re: Dynamic Filter

benford888 — Sun, 27 Jul 2025 21:40:40 GMT

I couldn't get the Complex Selector to work for my specific issue. any other ideas are welcome

Re: Dynamic Filter

benford888 — Thu, 31 Jul 2025 22:35:48 GMT

Hi. No, that solution didnt work for me. I'm still trying to find a solution

Re: Dynamic Filter

v-priyankata — Mon, 04 Aug 2025 09:24:30 GMT

Hi benford888
I have repro your scenario using dummy data. Please review the attached PBIX file and let us know if it is helpful. If you continue to experience any issues, feel free to reach out to the community.

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

Best Regards,
Priyanka.

Re: Dynamic Filter

v-priyankata — Thu, 07 Aug 2025 07:05:21 GMT

Hi benford888

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Re: Dynamic Filter

benford888 — Fri, 08 Aug 2025 02:04:13 GMT

Hi Priyankata,
I have reviewed the code and it appears that it's doing the opposite of what i want. The way the code works at the moment it filters for the last 13 months when a filter is selected, and shows all months when a filter is not selected. I want the opposite to occur. I want the default view to be rolling 13 months and the filter to show the filtered data output

Re: Dynamic Filter

v-priyankata — Thu, 14 Aug 2025 08:29:40 GMT

Hi benford888
This solved thread may help you refer below one, Please feel free to contact us if you have any further questions.
Solved: How to display the last 13 months of data in a Pow... - Microsoft Fabric Community

Thanks.

Re: Dynamic Filter

v-priyankata — Mon, 25 Aug 2025 15:53:15 GMT

Hi benford888

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.