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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
trebgatte
Impactful Individual
Impactful Individual

Bug? Selecting in the Next or in the Previous excludes Today

To all,

 

I have a scenario where I need to dynamically select a range of dates one month previous and six months forward. I've set up my Filtered rows to have a condition of In the Next 6 Months or In the Previous 1 Month. I got strange results. So I took it to the day level and what I found is that today's data is always excluded.

 

I'd expect these conditions to do a greater than or equal to today to the limit or less than or equal to today up to the limit. It appears to be doing a greater than/less than only.

 

Thoughts?

 

Treb Gatte, Project MVP | @tgatte | Blog 1 | Blog 2 | CIO Blog

5 REPLIES 5
foodd
Super User
Super User

Hello @trebgatte , can this legacy post from 2015 be closed or moved to an existing or new Issue?

 

Issues

If you have found a true bug or issue, you can make a post to the forum to let others know (and that would be very nice of you to do so). But if you want to get it fixed, you should post it in the Issues/Ideas (it varies) area of the community. Specifically, you should post it here:

Power BI - https://community.powerbi.com/t5/Issues/idb-p/Issues
PowerAutomate - https://powerusers.microsoft.com/t5/I-Found-A-Bug/bd-p/BugFound
PowerApps - https://ideas.powerapps.com


Ideas

If you have a new idea for functionality or how something should work, you can certainly start a thread on the community to solicit feedback on your idea, but you should also post the idea in the ideas section of the website and solicit others to vote on your idea. The development teams use the Ideas area of the communities to build their development pipeline and a significant amount of weight is placed on Ideas that have lots of votes versus those that do not. The ideas areas of the communities are here:

Power BI - https://ideas.powerbi.com
PowerAutomate - https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
PowerApps - https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

mllopis
Community Admin
Community Admin

Hi,

 

This behavior is currently by design. The "Is In Next/Previous" filters do not include current. You can achieve the "Is in Next or Current" behavior by using an advanced filter and combining both types of filters, as shown in the screenshot below.

 

month filter.png

 

Thanks,
M.

trebgatte
Impactful Individual
Impactful Individual

The challenge is that I'm usually trying to get a range of X next months or Y Previous Months. For example, give the previous three months and the next 6 months of budget data for a quarterly review.

 

While technically this is three sets of data(Current month, previous three months, next six months), this is approaching the issue in a mathematical way of thinking. The end user will be thinking of this situation as defining a range of dates, rather than distinct sets. I believe the range approach is what is used by Excel. As Excel sets the user perception, you may want to reconsider this behavior. It was an end user who brought this behavior to my attention. The discontinuity of approach with Excel will cause user confusion.

 

In order for your solution to work, I have to create separate datasets and merge. This seems inefficient and certainly not obvious.

Couldn't the issue be solved by adding a robust date dimension? I'm guessing you already have one, but on a high level what your describing is just different ways to segment dates. I would imagine the above example would work in some filtering. But on another note, why wouldn't you just expose the year and month to the end user and allow them to slice the data however they want? They can include or exclude every combination they want in real time without you having to preset anything for them...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

I'm reporting over Project Online data, which has a large number of records, leading to throttling issues with OData in Office 365 if you don't prefilter.

 

Dates, man do we have a plethora of dates as well. Smiley Happy  An assignment time-phased data set can easily have over a million records or more.

 

Best practice is to create a rolling time window subset, within which the user has the ability to filter. Hence, when the user found out the current month was excluded from their dataset, they were concerned.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors