Forum Discussion
Weekend slicer for chart view
Hi, I would like to have a slicer that would exclude weekend (Sat & Sun) from the calculation, but would also be able to see the report with weekends. Sample here.
I have created 2 different calculated fields, one is with weekend and the other one is without weekend.
How to create a slicer so that when i select "with weekend", the measure in the chart will change to the calculation with weekend?
2 Replies
Anonymous , Create a column
Weekday = WEEKDAY([Date],2)
then in slicer, add visual level filter weekday not in 6,7
But if you want to travel across date without weekend, then refer
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766
