How to display the dates in a slicer?

[sudhakar111]

Hello Everyone,

I have a slicer based on a calender table. Using the slicer i select the date range. The problem i am facing is how to display the 2 dates which are selected on the slicer. I tried using the Values(Calender[Date]). Also tried to use Min and Max functions. But Min and Max are giving the min and max values for the calender table,but not the selected dates on the slicer.

[TomMartens · Accepted solution]

Hey,

you can determine the minimum value of the daterange seleceted on the slicer by definig a measure (or assinging the statement to a variable) like so

minSelectedDate = 
MINX(ALLSELECTED('Calendar'[Date]),'Calendar'[Date])

to get the max values, just use MAXX instead of MINX.

Here is a little example, displaying the min value on a card visual

Hope this helps

Regards

Tom

[sudhakar111]

Thanks a lot.Worked perfectly.