Forum Discussion

Brenz's avatar
Brenz
Frequent Visitor
1 year ago
Solved

Power BI Relative Date Filter Exclude Weekends

Hello, I want to exclude weekends when using the relative date filter visual for dates. Currently, I have a table for dates including the a check IsWeekday. I add isWeekday as a filter for the whole ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Brenz 

    An alternative approach is to rank the visible dates relative to each other, using the dates themselves as values. The ranks are then compared to a numeric parameter. Dates with ranks greater than 0 and less than or equal to the parameter value are returned by applying a measure as a visual filter.

    Please see the attached sample pbix.

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

Brenz 

As far as I know, relative date type slicer users the hidden local date table to reflect the dates. It can observe the filters that you apply. 

I guess if you can disable auto time intelligence  and mark your date table as date table then it will remove all local date tables. See if that forces relative date slicer to follow the custom date table you created 

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!
Brenz's avatar
Brenz
Frequent Visitor
1 year ago

Hello thank you for your response,

As you suggested I disabled auto date/time intelligence and marked my date table as date table. However, this still doesn't fix the issue.