To show Published date for selected date in date slicer in PBI

[Anonymous]

Hi all,

I have 'date' slicer , for that slicer I have used column 'date' from content table

I have a table chart which includes 'title' and 'published date', i want to show title which have published dates for the selected month in date slicer

For example if i select june month in  date slicer between 6/1/2023 to 6/30/2023 , it must show titles which have published dates in june month between dates 6/1/2023 to 6/30/2023

please help

Thanks in advance

[amitchandak]

@Anonymous , Create a measure like

Dates sel = minx(allselected(Date), date[Date]) & "  " & maxx(allselected(Date), date[Date]) 

or

Dates sel = format(minx(allselected(Date), date[Date]),"mm/dd/yyyy") & "  " & format(maxx(allselected(Date), date[Date]) ,"mm/dd/yyyy")