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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Use [Today] in filters

Hello all

 

I’ve built a report which should be filtered in two ways.

StatusActiveOn should be every date less or equal today

StatusDeadOn should be every date greater than today

 

So far i added 2 slicers and selected the correct dates. But it should select the correct dates automatically, i tried adding a page level filter but it seems that i cant use any functions (Today..) or calculated columns there.

Is there a way to achieve the expected result without using the manual slicer option?

 

It should be the case that the date(today) automatically refreshes, but we already use a schedule on this report so i dont think that should be a problem.

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Anonymous,


I make a test using the following sample table.
1.PNG

I created a calculated column and drag it to page level filter, everything works well. Could you please share sample data of your table so that I can test?

chkdate = IF(Table1[Date]<=TODAY(),1,0)

2.PNG3.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
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

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Anonymous,


I make a test using the following sample table.
1.PNG

I created a calculated column and drag it to page level filter, everything works well. Could you please share sample data of your table so that I can test?

chkdate = IF(Table1[Date]<=TODAY(),1,0)

2.PNG3.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PattemManohar
Community Champion
Community Champion

@Anonymous Please try to have "Relative" date filters on the Slicer. That should work for you !!

 

image.png





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

Proud to be a PBI Community Champion




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.