Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 months ago
Solved

Dynamic Filter Selection Behavior in Power BI -Fiscal Year/Period

Hi , How can we make the filter selection behave like Qlik's functionality? Is it possible to achieve the same behavior in Power BI filters? For example, when Fiscal Year = 2026 and Fiscal Period ...
Need Help
Show and Tell
  • grazitti_sapna's avatar
    grazitti_sapna
    2 months ago

    Hi ashmitp869,

     

    Not Exactly the same but yes you can filter the calender date as per the selection from fiscal date and fiscal period using chiclet slicer custom visual.

     

    I've attached a sample .pbix file for you.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
2 months ago

Hi ashmitp869,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you grazitti_sapna for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    2 months ago

    Hi @ashmitp869,

     

    We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa