Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MrGlenn
Helper I
Helper I

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

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?

1 ACCEPTED SOLUTION
MrGlenn
Helper I
Helper I

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.

View solution in original post

3 REPLIES 3
MrGlenn
Helper I
Helper I

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
Community Support
Community Support

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)

veasonfmsft_0-1661307433155.png

Best Regards,
Community Support Team _ Eason

ribisht17
Super User
Super User

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors