Forum Discussion
Date Slicer
How to make the Date slicer without the slide range (slider) and only one date with calendar icon which should work as the real life calendar to slecte a particular date like if we slecet between , before or after, each case there is two slecteion of date showing by default, by i don want like that.
is it possible that with only one selction with calendar icon to go through more date ?
so that user can slecet any date any year or month????????????
This is a bit of a workaround, but it is how I do it myself.
I go to visual and pick after.
Than I reduce the size of the visual so it only shows the top date (even thought both date technily are there.)
You can add a filter in dax that makes sure you filter the entire page to the minimum selected date.
I hope this helps. 🙂
12 Replies
So do you want to only see data for that specifik date?
Or do you want to only show one date in your slicer, but show all dates in the report upto that date?yes 1st one want to only see data for that specific date
This is a bit of a workaround, but it is how I do it myself.
I go to visual and pick after.
Than I reduce the size of the visual so it only shows the top date (even thought both date technily are there.)
You can add a filter in dax that makes sure you filter the entire page to the minimum selected date.
I hope this helps. 🙂
What you need to do
Delete the current slicer
Insert the Date Picker visual (not the regular slicer)
Drop Calendar[Date] into it
And BOOM - you get the exact UI you want:
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Hey, I dont know which one exaclty as there are many date picker, most of them are paid... can you pls provide the link which you are talking about? if it is free.
It cost a dollar a month per user (but the first month is free.)
Here is how you find it.Than search for date picker and you will find it.
Use the "Before" slicer type, then hide the 1st block, and use Max(Date[Date]) in your measures
