How can we improve Power BI?

relative date slicer exclusions

The 'relative date filtering' option in the 'Filter Type' drop-down is a great tool, but it doesn't contain the ability to exclude dates.

It would be great if I could select "Show items when the value: is NOT in the last day, month, or year" rather than only being able to select inclusive dates.

This is specifically for the use-case of looking at rolling Same Store Sales numbers. I need to be able to exclude customers whose first sales dates are in the last 12 months. A Relative date filtering selection for this would look like "Show items when the value: is not in the last 12 months".

Thanks for reading!

4 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Curtis Ramirez shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John Palmer commented  ·   ·  Flag as inappropriate

    I have a similar requirement. I need to show a report with items due in 30, 60, 90 day windows. I need to be able to show "is in the next 60 days AND is NOT in the next 30 days".

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.