Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

start and end date in slicer selection

hi have start and enddate as below . I am trying to change the date of start date anything after june 9th which is greater than end date . Even if i select  that i am seeing it is not being able to select it . I can change it only after the end date is chnaged . Like for example if i select end date to dec 1st 2019 . Then i am able to select anything less than dec 1st 2019 but not after that .I know that we cannot do that i am giving a try to change the start date first followed by end date . Is it vice versa in power bi ?

 

date.jpg

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Yes. Move the end date and then move the start date. I could give 100 comparisons as to why it makes no sense to try to move the start date beyond the end

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

This is a problem in Power BI and NOT the logical way to do things (name another program that works well and does this!). Some of the reasons this is terrible logic:

  1. When we change a field, that field should change and if need be other fields update to suit (so when changing start, end date should change).
  2. In english we read and write left to write, so we SHOULD be putting in a start date first!
  3. When entering dates we always say from and to (who says to and from, that would not make sense), therefore we should be able to change the start date first.

I have written an issue idea at https://community.powerbi.com/t5/Issues/Date-validation-acts-incorrectly-with-start-and-end-dates-in... so if this problem annoys you, go there and vote it up (and comment if you have any ideas how to improve it).

Anonymous
Not applicable

Why are you wanting to see data past the end date? Why not just move the end date? Perhaps a slicer isn't what you are looking for?

Anonymous
Not applicable

@Anonymous : i am not moving the start date greater than end date . While the chnaging the dates here is my detail explanantion . my user started checking the date from jan 1st to jan 31st then he wanted to analyse the data from feb 1st to feb 28 . In the second case in general he started chahing the start date to frb1st then proceed of chaging the end date to feb 28( where the current date was jan 31st) . In this case we found this scenerio .

 

2) So in general do we need to change the end date first then the start date ?. I am just asking for user training in this case

 

Hope you got it?

 

3) can we acheive this in anyother way ?

Anonymous
Not applicable

Hi,

 

I am also having some concern on this.

 

Normaly when we give date inputs first we select the start date and then end date. But if default start date is greater than the new start date the slicer visual will not allow to proceed. 

 

So i had to tell users that first they need to change the end date and subsequently select the start date.  That confuses users. 

 

Regards,

Maddy

Anonymous
Not applicable

Yes. Move the end date and then move the start date. I could give 100 comparisons as to why it makes no sense to try to move the start date beyond the end

Completely agree that this behaviour is a completely broken UX.  There is no warning at all when a user selects a start date which comes after the end date.  It just does nothing, so the user things the product is broken and we have one unhappy Power BI user extra.

There are at least two solutions:

* a small tooltip warning if you select a date which is not valid.

* disable all invalid dates in the datepicker like every website does.

 

I don't understand why this non-sensical behavior can last for years in Power BI.  I just took a quick look at the source code of this slicer (

 
It is just a matter of a few extra lines.  I would be happy to contribute this fix.
Anonymous
Not applicable

ya that makes sense . I can proceed with that for training part

Anonymous
Not applicable

@Anonymous : can you help me with this thread please if you have idea on DAx :

https://community.powerbi.com/t5/Desktop/ignore-the-top-N-filter-for-calculation-of-percentage-value/m-p/710322#M342961

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.