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
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!
Imagem de fundo



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.