Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I want to use Filter to exlclude some range of date For example from May 2nd to June 15th
can anyone how to do this?
Solved! Go to Solution.
@usman96 There are many ways to apply filters, whether that is in DAX or using Power BI... As a straightforward approach you can use the Filters section on visual, page or report level and use advanced filtering.
You would select the "is on or before" May 2nd, and "Is on or after" June15th...
@usman96 There are many ways to apply filters, whether that is in DAX or using Power BI... As a straightforward approach you can use the Filters section on visual, page or report level and use advanced filtering.
You would select the "is on or before" May 2nd, and "Is on or after" June15th...
but I want to exclude these dates by using this advanced filter
@usman96 ah, slight correction in the filter, use "and" instead of "or" - that should pull everything before and after those dates, thus, excluding that in between date range.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!