Dynamic Filter

[benford888]

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

No Filter appliedlast 13 months data when no filter applied

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

2023/2024 Fin year selected

[benford888]

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

[v-priyankata]

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.

[Greg_Deckler]

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

[benford888]

I'll give it a go. thanks Greg