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
details
Helper I
Helper I

table filtered by dinamic dates

Hello everyone,


I'm trying to filter a table using multiple dates.

details_0-1641574390595.png

 

So i need to filter this table to show the data filtered by cancelation date. But not a regular filter... I need to get all the data where cancelation date = "01/01/1900 and > Selectedvalue in slicer "cancelation date".

 

Is it possible ?

Thank you

 

 

 

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

Hi @details ,

 

 According to

 

1. I need all the 01/01/1900 and, for example, all after 01/01/2021...

 

Please add a calendar table for slicer, and then create a flag measure:

ForSlicer = CALENDAR(MIN('Table'[cancelation date]),MAX('Table'[cancelation date]))
Measure = IF(MAX('Table'[cancelation date])=MIN('ForSlicer'[Date]) || MAX('Table'[cancelation date])>=MAX('ForSlicer'[Date]),1,0)

And apply it to filter pane:

Eyelyn9_0-1642066332181.png

 

2. I need to create a new collum in the table that will change according the do value that i have selected in the slicer

The column is static, it could not be dynamically changed by the slicer. You could use measure instead.

 

 

Best Regards,
Eyelyn Qin
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

6 REPLIES 6
v-eqin-msft
Community Support
Community Support

Hi @details ,

 

 According to

 

1. I need all the 01/01/1900 and, for example, all after 01/01/2021...

 

Please add a calendar table for slicer, and then create a flag measure:

ForSlicer = CALENDAR(MIN('Table'[cancelation date]),MAX('Table'[cancelation date]))
Measure = IF(MAX('Table'[cancelation date])=MIN('ForSlicer'[Date]) || MAX('Table'[cancelation date])>=MAX('ForSlicer'[Date]),1,0)

And apply it to filter pane:

Eyelyn9_0-1642066332181.png

 

2. I need to create a new collum in the table that will change according the do value that i have selected in the slicer

The column is static, it could not be dynamically changed by the slicer. You could use measure instead.

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Perfect! Thanks for your help!

JaromBIDEVatDK
Helper II
Helper II

Yes this is possible. You can create a measure that will be the indicator if those paramters match. The measure will need to be another column in the table. You would also want to make sure the "show items with no data" is not selected. 

 

Measure =

var minSelectedDate = MIN(ColumnForSelectionSlicer)

var maxSelectedDate = Max(ColumnForSelectedSlicer)

return

Calculate(MAX(CancelationDate), Filter(TableWithCancelationDate, CancelationDate = "1/1/1900" && CancelationDate > minSelectedDate  && CancelationDate < MaxSelectedDate))

 

I'm sorry but i'm a bit confused.

 

I need to create a new collum in the table that will change according the do value that i have selected in the slicer ?? I really didn't understand, sorry

 

 

freginier
Solution Specialist
Solution Specialist

 

I don't understand the problem with your slicer.. You can't automatically filter the table with the slicer ?

i need multiple dates filtered.. I need all the 01/01/1900 and, for example, all after 01/01/2021...

If i have data beetween 01/01/1900 and 09/01/2022 using the slicer i will need to mannualy check more than 370 records...

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.