Skip to main content
cancel
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

Reply
Krunal_Bhavsar
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 : 

Krunal_Bhavsar_2-1713540557915.png

 

Problem I am facing : 

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

Before 

Krunal_Bhavsar_8-1713541770364.png

 

After changing the custom date filter.

Krunal_Bhavsar_9-1713541921506.png

 

What could I do to solve the problem ?

(Note:  Interaction is enabled in relative filter) 

Krunal_Bhavsar_7-1713541657681.png

 

Thanks in Advance.

3 REPLIES 3
v-yifanw-msft
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.

lbendlin
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

Announcements
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.