Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@Bharathi_99 , 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")
User | Count |
---|---|
94 | |
78 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |