Forum Discussion
Power BI Relative Date Filter Exclude Weekends
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.
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
|
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.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!
