Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

How to create Relative and dynamic Date filter ?

Problem satement : I have to prepare a filter where a manager can select an out of service date and from that date to last month, last week and last year he wants to get the bar chart of the response time.


What I did : Made 2 out of service date slicer one with the between and one with the relative both sources are same which is out of service date.


Source data : 



Problem I am facing : 

When I select a particular range as given below, relative date filter is not changing accordingly.




After changing the custom date filter.



What could I do to solve the problem ?

(Note:  Interaction is enabled in relative filter) 



Thanks in Advance.

Community Support
Community Support

Thank you @lbendlin  for your prompt reply.

Hi @Krunal_Bhavsar ,
Could you provide some example data such as detailed data (without sensitive information) and your desired output. This will allow us to better reproduce and solve the problem you are experiencing.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.


Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

That would be a question for your data model. Please provide more details.

Hi there I have updated the questions with the proper screen shot, Thanks for replying

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.