DimDate Slicer - Show Min & Max Date Of A Related Table

[MrGlenn]

Hello,
When using a DimDate table in a slicer, I get the entire range of the dates of the DimDate Table.
Is there a way to make a dynamic filter on the dates of the slicer?
I've created measures to get the dynamic min and max date vaules, how can I add these to the slicer filter?

[MrGlenn · Accepted solution]

To get this to work, I made a new table through query by

1. apending the 2 tables,
2. remove all the columns other than the date column,
3. remove duplicate dates.
4. link the relationships of the original 2 tables to this new date table.

From here I use this new table as the date references in the slicer.

[v-easonf-msft]

Hi, @MrGlenn 

Try to add a calendar table and create a slicer based on that table.

Then you need to add a measure like below and apply it to visual filter pane.

filter = IF(SELECTEDVALUE('Calendar Table'[Date])>[mindate]&&SELECTEDVALUE('Calendar Table'[Date])<[maxdate],1,0)

Best Regards,
Community Support Team _ Eason

[ribisht17]

@MrGlenn 

Here is an example with PBIX https://community.powerbi.com/t5/Desktop/show-max-date-slicer-in-button/m-p/2348830

Thanks,

Ritesh