cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmoriau
Helper III
Helper III

Date slicer visual

Hi,

 

We have some troubles using date slicers in Power BI.

> you cannot select a date in from that is older than already selected in to (or otherwise). Very anoying when you continue need to change dates.

> date format is not like we set in desktop. In desktop we see dd/mm/yyyy but in our dashboard we see it as following: d-m-yyyy. 
(I think it's because of the language settings in dataset? There it is set as "dutch", when I change it to "english" we see mm/dd/yyyy).

> is there a slicer where you can select from & to date in 1 calendar field like this:

dmoriau_0-1623849197181.png

Now we need to open calendar structure 2 to select. 

 

All information can be helpfull. 

 

kind regards,

Davina

 

1 ACCEPTED SOLUTION

Hi @dmoriau ,

 

You can use the timeline slicer the you can select from and to date in a calendar. Please refer to https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380786?tab=overview

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

3 REPLIES 3
dmoriau
Helper III
Helper III

Are there other date slicer visuals that is good in use?

Hi @dmoriau ,

 

You can use the timeline slicer the you can select from and to date in a calendar. Please refer to https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380786?tab=overview

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

collinq
Super User
Super User

Hi @dmoriau ,

 

The first thing to consider is that you should be using a Date dimension table.  And that should be linked to your other date fields - as that will allow you to have all the dates in a range.  (See Why Create a Date Table in Power BI? : :: Welcome To EPM Strategy :: for a longer explanation and a sample file.)

 

On the Date slicer you can have many options on how to use the Dates.  I am not sure what precisely you are trying to do but if you select the little carat/down arrow symbol in the corner of the standard slicer when you are using a date field you will see numerous options.

collinq_0-1623851217308.png

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!