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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
praneshjuwale
New Member

Set end date as todays date in date slicer keeping date range intact

Hi Folks,

 

I have used date slicer with a date range as followed:

 

DateSlicer_DefaultDateRange.PNG

 

This is working properly.

Now i want to show end date as todays date but keeping the date range intact as above.

 

How to modify for the same?

 

Thanks in advance.

 

Pranesh M Juwale

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@praneshjuwale,

 

You may simply add a calculated table.

Table =
CALENDAR ( DATE ( 2018, 1, 1 ), TODAY () )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Sam,

thanks for the update.

 

Table =
CALENDAR ( DATE ( 2018, 1, 1 ), TODAY () )

 

But this will give me a slicer as today with end oo the date range, I don't want that.  

I want the slicer to have end date parameter in the visual as today  and the slicer can be moved manually ahead of the todays date till the end of the date range.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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