Forum Discussion

benford888's avatar
benford888
Frequent Visitor
1 year ago
Solved

Dynamic Filter

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

10 Replies

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    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's avatar
      benford888
      Frequent Visitor
      1 year ago

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

      • v-priyankata's avatar
        v-priyankata
        Community Support
        1 year ago

        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.

  • benford888's avatar
    benford888
    Frequent Visitor
    1 year ago

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

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    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's avatar
      benford888
      Frequent Visitor
      1 year ago

      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