How to create Relative and dynamic Date filter ?

[Krunal_Bhavsar]

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.

Before 

After changing the custom date filter.

What could I do to solve the problem ?

(Note:  Interaction is enabled in relative filter) 

Thanks in Advance.

[Anonymous]

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.

[lbendlin]

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

[Krunal_Bhavsar]

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