Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I'm trying to filter a table using multiple dates.
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
Solved! Go to Solution.
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:
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.
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:
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!
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
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...
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |