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