Forum Discussion
Multiple Date Columns, single date slicer.
Hi Dharm ,
Please try below steps.
1. my test table
Table:
2. add a fields parameters and add a slicer
3.add a table visual and add two date slicer for "Build_Date" and"Disposal_Date"
Please refer attached .pbix file
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dharm , You can use single date slicer when both dates need same date range/period to filter
You can join both of them with same date table and one join will be inactive. that you can activate using userelationship
calculate( SUM(Table[Amount]),USERELATIONSHIP ('Table'[Build_Date], 'Date'[Date]))
calculate( SUM(Table[Amount]),USERELATIONSHIP ('Table'[Disposal_Date], 'Date'[Date]))
if they need different periods you need two date tables or use the date itself in the slicer
refer
Thanks for this Amit, it's definitely in the right direction. However one requirement I have is to list the properties that are being filtered. For example if the column selection in Build_Date and the date slicer is set to 1st Jan 2021 to 30th Jun 2022 then list all the properties built during that period. Similarly if disposal date is selected and the date slicer is set to the same period then list the properties disposed off in the period. The solution will work for a count but I need the list to be show.