Power BI Relative Date Filter Exclude Weekends

[Brenz]

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 page as well as a relative date filter for the last X days. The problem is the relative date filter still includes the weekends even though for the whole page, only weekdays are included. Is there an alternative way to filter where the user can interact with the filter i.e. inputting last X days? 

Here's a screenshot of the report:

[v-menakakota]

Hi @Brenz  ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[danextian · Accepted solution]

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]

@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]

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]

@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!