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

[v-priyankata]

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.

[benford888]

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

[v-priyankata · Accepted solution]

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.

[v-priyankata]

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.

[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.

[benford888]

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

[v-priyankata]

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.

[Greg_Deckler]

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

[benford888]

I'll give it a go. thanks Greg