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
bibhash_21
Frequent Visitor

Get Dynamic date in slicer

Hi,

I have 2 date slicer, I want to when I select a date in 1st slicer then 2n slicer contain only greater date of 1st slicer.

I have create a calender table 

Date1 =
ADDCOLUMNS (
CALENDAR (DATE(2019,6,1), NOW()),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"DateTime",FORMAT([Date],"YYYY/MM/DD 8:00 AM/PM")
)
and also create a 2nd calender table
CurrentDate =
var sdd = SELECTEDVALUE(Date1[Date].[Date],NOW())
RETURN
ADDCOLUMNS (
CALENDAR (sdd, DATE(2020,5,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"DateTime",FORMAT([Date],"YYYY/MM/DD 8:00 AM/PM")
)
But this is not work.
help me pls.
 
Thanks 
Bibhash Jha
1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi, @bibhash_21 

First, you should know that calculated column and calculated table can't be affected by any slicer. 
Notice:
1. Calculated column/table not support dynamic changed based on filter or slicer, they  are "static" , will not respond to filters.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @bibhash_21 

First, you should know that calculated column and calculated table can't be affected by any slicer. 
Notice:
1. Calculated column/table not support dynamic changed based on filter or slicer, they  are "static" , will not respond to filters.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thaks for answer,

Now, How can achhive that.


@v-lili6-msft wrote:

hi, @bibhash_21 

First, you should know that calculated column and calculated table can't be affected by any slicer. 
Notice:
1. Calculated column/table not support dynamic changed based on filter or slicer, they  are "static" , will not respond to filters.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

Best Regards,

Lin



 

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.