The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
I tried to follow the below video to set the default slicer as current month in PowerBI. And it works well on my other report.
https://www.youtube.com/results?search_query=Set+Default+Slicer+Selection+to+Current+week
But this time I would like to set the slicer to current week. I have created the date table as I need a week cycle to start from Thurs to Wed.
I can set today as "Current Week". But I can't figure out a way to replace the remaining days as "Current Week" as well.
Appreicate all your help!
Solved! Go to Solution.
@basyan1991 , Try like
var _st= today() +-1*if(WEEKDAY(today())<4,WEEKDAY(today())+3,WEEKDAY(today())-4)
var _end = _st+6
return
if([Date]>=_st && [Date] <=_end, "Today", [Date] &"")
Hello,
you should have a week number column, then you use in you measure were if(weeknum(today()) = week number column,"Current week")
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Thanks for replying! But from what I understand this wont be able to work as I have a different week cycle setting. Starting from Wednesday to next Thursday.
Not sure whether I understand this correctly.
@basyan1991 , Try like
var _st= today() +-1*if(WEEKDAY(today())<4,WEEKDAY(today())+3,WEEKDAY(today())-4)
var _end = _st+6
return
if([Date]>=_st && [Date] <=_end, "Today", [Date] &"")
I have tried that on my report. It works perfect now!
Thanks for your help!