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
Balakrishann
New Member

Custom Visual Filter- Between option for date field

Hi,

 

  I need to filter the date field with "between" function, i couldn't find the option for this .Can someone please help?

 

Regards,

Balakrishnan

 

2 REPLIES 2
Anonymous
Not applicable

Hi @Balakrishann,

 

   if you want to use a function like "between" in DAX there is DATESBETWEEN() that allows you to create a view of your datas.

Here a schema of what to do:

 

betweenDates.png

 

But I think that the solution provided by @Anonymous is better.

 

Anonymous
Not applicable

Hello @Balakrishann

 

You can do this on the visual filter, when you use date field.

 

You open the visual filter and swith from "basic filter"  to "Advanced filter":

First.png

 

When you're in the advanced filter option you can choose the lower and upper boundaries :

 Apres.png

 After that, you apply and it should work.

 

Let me know if that's you're wanted (or not 🙂 ).

 

Sébastien

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.