Date Slicer

[Khushboobarai]

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????????????

[Kedar_Pande]

@Khushboobarai 

Use the "Before" slicer type, then hide the 1st block, and use Max(Date[Date]) in your measures

[Jaywant-Thorat]

What you need to do

1. Delete the current slicer

2. Insert the Date Picker visual (not the regular slicer)

3. 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!!

Linkedin: https://www.linkedin.com/in/jaywantthorat/

[Khushboobarai]

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.

[Jaywant-Thorat]

Go to
Get more Visuals -> Inforiver Super Filter
and format ir according to ur requirement.
very effective visual for calendar filter.

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Linkedin: https://www.linkedin.com/in/jaywantthorat/

[ThomasWeppler]

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.

[ThomasWeppler]

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?

[Khushboobarai]

yes 1st one want to only see data for that specific date

[ThomasWeppler · Accepted solution]

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. 🙂

[Khushboobarai]

Thank you worked but instead filter min measure to whole page, i did only to the slicer visual of date itself works perfectly fine. 

[Khushboobarai]

I tried this way too, but this will not allow to choose the previoud date right?
suppose for now you selcted 1-1-2020 the visual will show the data for this date, then you select 30-1-2020 then if yo agin want to go to the previous of 30 jan like 25 or 2 0r 3 then the calendar pop up show those date as diabled,

Also the whole report or the visual wil show after dates as if you slected 01 01 2020 then it will shwo all the data from 01-01 to its max date

but why it can't be specific?
why the power bi doesnt allow only to show 01 jan ka data

[ThomasWeppler]

Hey @Khushboobarai 
Ok I think I found a better solution.

1. You can go to your calender table and add a new column like this

Date 2 = Calender[Date]

2. Change the format to Short date

3. Change the type to text

4. Sort Date 2 by date

Add date 2 in your filter and add the search option.

select the slicer and go to visualization - > options and pick single selecti.

[Khushboobarai]

That will just look like category, which user don't want, they need proper calengdar view to see for the particular date.
Anyway, I did it successfully.

thank you so much for your help too.