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
Ossy81
Helper I
Helper I

Remove time from date filter in filter pane

Is it possible to remove the time option within the date filter in the filter pane? 

 

2020-05-26 11_46_59-Amazon Vendor Dashboard  - Power BI Desktop.png

5 REPLIES 5
amitchandak
Super User
Super User

@Ossy81 , Is the Data type is Date or datetime. try with Datatype date.

That;s already something i checked. It's unlikely a miss in PBI

PattemManohar
Community Champion
Community Champion

@Ossy81 No, you can't if you are using Filter Pane and Advanced Filtering option for Date or DateTime fields. 

 

To achieve your requirement, I suggest to use the slicer and select Between option

 

 
 




Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




That's a pitty.. I want to have less filters on the dashboard itself.

And indeed another suggestion/question i had was to have a BETWEEN operator in the filter 😄

 

I'll put it in UserVoice and see if this will be picked up

Did you @Ossy81  get anywhere with this? 🙂 I've got exactly the same issue and my users are confused with unnecessary time filters as my field in question is type date.

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.