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.

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.

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

Brenz 

Connect your model to DAX studio and check if local tables are deleted. If not then close and reopen your report and check again.

As I mentioned, I am assuming removing local date tables would force the related date type slicer to follow the custom date table you created. IF that is not the case then I think this approach might not work. 

 

May be you need to check if there is any custom visual which solves this purpose. 

 

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!