How to automatically select Max Date upon opening pbix file

[Anonymous]

Hi all,

Is there a method in which Power BI automatically selects the latest date you have in your data, when you open the file?


Thanks in advance!!

Kind regards,

C

[amitchandak · Accepted solution]

@Anonymous , typically you can use relative date slicer of can have a column like this you date table

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Is Today = if('Date'[Date]=maxx(Sales,[Sales Date]),"Max Date",[Date]&"")

As this a varchar you mark the date as its sort column. And Use Max date as the filter

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/i-have-two-dates-using-measures-and-want-to-set-these-dates...

[amitchandak]

@Anonymous , Refer if this can help

https://www.youtube.com/watch?v=c_MjL1Cngbs

[Anonymous]

Thanks for your reply, but nope sorry that isn't what I'm looking for

[amitchandak · Accepted solution]

@Anonymous , typically you can use relative date slicer of can have a column like this you date table

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Is Today = if('Date'[Date]=maxx(Sales,[Sales Date]),"Max Date",[Date]&"")

As this a varchar you mark the date as its sort column. And Use Max date as the filter

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column