Forum Discussion
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 ...
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.
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.