Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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
Thanks a lot.Worked perfectly.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |