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 = 07 and 08 are selected:
Calendar Year 2025 should automatically become selected/active, while all other calendar years are disabled (greyed out).
Month Jan and Feb as active m, while all other Month are greyed out.

If this can be implemented in Power BI? A sample Power BI file (.pbix) or example implementation would be greatly appreciated.

 

 

 

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!

3 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    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