Forum Discussion

ginalu's avatar
ginalu
Icon for Helper I rankHelper I
2 years ago
Solved

Automatically Setting Default Date Range in Power BI Filter

Question: I want to set the default range of a date slicer in Power BI to automatically cover the full range from the earliest date to the latest date available in the data. I also want this range t...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi, ginalu  if you see this, it means that something in your model on this date appears...
    The function takes all the date fields of all tables in the model...
    If you want to limit the slicer by specific column you can create a flag measure like 

    and then use this flag as a filter for the slicer :

    The updated pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

ginalu's avatar
ginalu
Icon for Helper I rankHelper I
2 years ago

Hi Ritaf1983 ,

 

Thank you for your response. I tried the suggestion you provided, but I noticed that the filter date is showing a future date of 2034. I would like it to display the maximum value of the existing date data instead.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi, ginalu  if you see this, it means that something in your model on this date appears...
The function takes all the date fields of all tables in the model...
If you want to limit the slicer by specific column you can create a flag measure like 

and then use this flag as a filter for the slicer :

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly