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
Krutigawale33
Responsive Resident
Responsive Resident

Dynamic selection of date in slicer when end date is reach

Hello All,

I have an requirement, currently Oct, Nov, Dec, Jan, Feb data is selected in the slicer and , data is showing in the graph.

So when for next month the end date will reach the slicer should automatically select March month, and the data should display in the graph.

End date is showing in below table for each month .

 

So I would like to make slicer dynamic based on the condition of  when end date meet and should display the data in graph.

Krutigawale33_1-1615900700975.png

 

FiSCAL MonthMCAL_PERIODSTART_DATEEND_DATEActualPlan
Jan 41/2/20214/30/20215057
Feb51/30/20212/26/2021476
Mar62/27/20214/2/2021514
Apr74/3/20214/30/2021729
May85/1/20215/28/2021465
Jun95/9/20217/2/20213739
Jul107/3/20217/30/20216613
Aug117/31/20218/27/2021563
Sep128/28/202110/1/2021568
Oct13-Oct10/30/20208838
Nov231-Oct11/27/2020575
1 REPLY 1
amitchandak
Super User
Super User

@Krutigawale33 , That not possible, You can have a flag like

 

last six month =
Switch( True(),
[Date] >= eomonth(today(),-6)+1 && [Date] <= eomonth(today(),0) ,"Last Six" ,
[Date] & ""
)

 

and select that.

 

Refer: https://www.youtube.com/watch?v=hfn05preQYA

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.