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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Narukkp
Helper V
Helper V

How to hide Relative Time filter in Power bi service for Date column

Hi Team,

 

  1. In Report panel date filters are not working as expected in power  service for Date data type columns. i.e. I have a Date Range(column as date datatype) filter in report level filter panel and when I am observe there are 4 filter types -Advance Filtering, Basic filtering , Relative Date, Relative Time  are showing in service but in my desktop it is showing only 3 types – Advance Filtering, Basic Filtering, Relative Date. Can someone  help me how to remove or hide the Relative Time in service

Relative Time Picture.pngDesktopDatetypes.png

2. In Advance Filtering when I am selecting the is on date & is on after dates but here it is taking current time in time interval place. But in my desktop when I am selecting the dates it is considering the 12:AM by default. So can someone help how to stop the current time in time interval place.

Advance Filtering.pngAdvance Filtering_Desktop.png

2 ACCEPTED SOLUTIONS
Icey
Community Support
Community Support

Hi @Narukkp ,

 

1. The version of Power BI Service is basically kept up to date. So, you can find "Relative Time" filter in Power BI Service.

    But in Power BI Desktop, if you don't update it, it won't show the new features.

    Currently, there is no workaround to hide it. It is suggested to post your idea on this post: 

Share your thoughts on the new relative time filter and slicer (preview).

 

 

2. I have not found other workarounds currently. 

    Maybe this is a bug, so I have reported it internally. I will update the status here in time.

 

 

 

Best Regards,

Icey

 

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

View solution in original post

Icey
Community Support
Community Support

Hi @Narukkp ,

 

The issue "in Power BI Service, default time in Advanced filtering of Date column changes to the current time after choosing date" has been fixed. Please check.

 

 

Best Regards,

Icey

 

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

View solution in original post

5 REPLIES 5
Icey
Community Support
Community Support

Hi @Narukkp ,

 

The issue "in Power BI Service, default time in Advanced filtering of Date column changes to the current time after choosing date" has been fixed. Please check.

 

 

Best Regards,

Icey

 

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

Icey
Community Support
Community Support

Hi @Narukkp ,

 

1. Relative Time filter is a new type of filter announced this month. 

Given that this is a preview feature, we greatly appreciate any feedback in terms of what you liked about the feature and how we can improve it!

 

2. Try this: 

First click on the default time, 12, then select date. Then, the time won't become the current time.

advanced.gif

 

Best Regards,

Icey

 

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

Hi,
Thank you @Icey 

1) But here my ask is i have not used the latest version and also my colum data type is date then why we have to show retiave time filter in drop down?

2) It is very dificult to teach the end user like below workaround (First click on the default time, 12, then select date) is there any another way to stop this current time option ?

 

Icey
Community Support
Community Support

Hi @Narukkp ,

 

1. The version of Power BI Service is basically kept up to date. So, you can find "Relative Time" filter in Power BI Service.

    But in Power BI Desktop, if you don't update it, it won't show the new features.

    Currently, there is no workaround to hide it. It is suggested to post your idea on this post: 

Share your thoughts on the new relative time filter and slicer (preview).

 

 

2. I have not found other workarounds currently. 

    Maybe this is a bug, so I have reported it internally. I will update the status here in time.

 

 

 

Best Regards,

Icey

 

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

Greg_Deckler
Super User
Super User

If I were to hazard a guess I think you are fighting a losing battle on this one. If I had to guess, the relative time is a new feature that has been released in the Service and will make it's way to the Desktop. 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors