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!

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!