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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
lucpaymetals
Frequent Visitor

Current Day slider button

Hello,

I need a button that if you click on it, it will filter everything by the current day. I need to put this in a slicer so i can filter everything by it. 

Does anyone know how todo this.

Currentday = IF(DAY(TODAY())=DAY(ValueEntries[Document_Date].[Date]),1,0)

This is what I have but it does not seem to work.

Thank you.

1 REPLY 1
marcelsmaglhaes
Super User
Super User

Hey @lucpaymetals 

 

You need create a COLUMN in your table, and not a measure. 


Current Day = IF(ValueEntries[Document_Date] = TODAY(), 1,0)
 
If this post helps, please mark as solved to help other users find quickly in our community!

Regards,
Marcel 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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