Forum Discussion
Dynamically latest date selection in power bi single select slicer
My req is when report will be opened in power bi services, by default latest date will be selected in a single select slicer. Consider in import mode there are 10 dates are coming nd assigned to a sl...
Anonymous
I'm not sure whether the below solution will help you.
Create a calculated column.
Filter Column = IF(MAX('Table'[Date])=[Date],"Latest",FORMAT([Date],"dd-mm-yyyy"))
Then use this column in the slicer.
@nandukrishnavs no it is not helpful.