Forum Discussion

kaweckil's avatar
kaweckil
New Member
2 years ago
Solved

Set a Dynamic MAX date

Hi,   I was wondering if PowerBi supports a measure to dynamically update the max date in my dates slicer. That is, the max date should set to the most recent date in my data without requiring the ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago


    - create a string representation of your date column, replace the latest date with a string "Latest"
    - sort that new column by the original date column
    - add a slicer or visual/page/report level filter
    - set the filter to "Latest"
    - publish the pbix to the workspace/app

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi kaweckil 

     

    Thank you very much lbendlin for your prompt reply.

     

    lbendlin's answer fits the situation you're looking for. Have you solved your problem? If not, allow me to add some details.

     

    Create a column.

     

    Max date = 
IF(
    'Table'[Date] = MAX('Table'[Date]),
    "Max date",
    FORMAT('Table'[Date], "mm/dd/yyyy")
)

     

     

    Solved: How to set default MAX date in Slicer - Microsoft Fabric Community

     

    To create a slicer, select Max date. In this case, the slicer will be updated based on your date, with the default "Max date" selected.

     

     

    Regards,

    Nono Chen

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

     

     

Mohammed_Sami2's avatar
Mohammed_Sami2
Regular Visitor
2 years ago
Create the Calculated Column:-
IsLatestDate = 
IF(
    'Date_Table'[Date] = MAXX(ALL('Date_Table'), 'Date_Table'[Date]),
    "Latest",
    FORMAT('Date_Table'[Date], "yyyy-MM-dd")
)


Sort the Column:-
Go to the Modeling tab, select the new column, and choose Sort by Column. Select the original date column.


Add to Slicer:-
Add the IsLatestDate column to your slicer. Set the slicer to “Latest” to dynamically update to the most recent date.