Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gbxn
Regular Visitor

Date slicer only up to today's date

‎08-10-2023 10:41 PM

Hello!

 

My data has dates from January 1 to December 31, so my current date slicer has also the same range.

 

How do I make a slicer with a start date still January 1, but the end date is the date today?

 

Thanks!

Labels:
Message 1 of 3
230 Views
0
2 REPLIES 2
Ahmedx
Super User
Super User

‎08-10-2023 11:11 PM

look,
up you might be looking for it

https://youtu.be/VaJ10ilXp6Y?t=7

Message 3 of 3
192 Views
0
Khajamohiddin
Helper I
Helper I

‎08-10-2023 10:56 PM
Dates Till Today = IF(table[Datecolumn] < TODAY(), table[Datecolumn], BLANK()) then apply filter to remove blank from the slicer
 
If I answered your question, please mark my post as solution, Appreciate your Kudos
Message 2 of 3
213 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All