Power BI - Slicer Dropdown Default Date

[kemmerrc]

I have a date filter on my page. I created a true/false value table (Table 2) and a measure to get the most recent date on my dropdown filter. I used the Preselected Slicer to create the visual with Fields = Date, Pre Selection = Measure, and Dirty Status = Table. I then set the Format Display as Dropdown. 

Table 2 = {TRUE(),FALSE()}

Measure = var a=MAXX(ALL('Table'),[Column1])

return IF(MAX([Column1])=a,TRUE())

All of this worked  - in that the dropdown slicer does display the most recent date BUT only the most recent date shows on the slicer. How can I get the slicer to list all the dates, allowing the user to change the date to an earlier date? I want it to continue to to default to the most recent date as data is added or as user click in/out of the link/dashboard?  

[ronaldbalza2023 · Accepted solution]

Hi @kemmerrc , found several online tutorials on setting dynamic dates in Power BI date slicers. One helpful resource is Set a Dynamic/Default/Changing Date in Power BI Date Slicer Let me know if this aligns with your needs.

[Daniel29195]

@kemmerrc 

try using this custom visual 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠