Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey,
Actually I'm using a date slicer, but I'd like to start and end date to be automaticly selected depending on the current week, but the user will still have the option to change thoose dates on the original scale.
For example, from
if we are the 2020/08/24 I want my default start and end date to be 2020/08/24 and 2020/08/30 :
Hey,
Any luck with this? I am running to the same issue.
Hi @Anonymous ,
Would you please try to add a measure filter in your visual level filter :
Measure = IF(WEEKNUM(MAX('Table'[Date]),2) = WEEKNUM(TODAY(),2),1,0)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you @v-deddai1-msft , but this is not what I'm looking for, I want the min and max range of my slicer to be the same, I just want the selection of the start and end date to be updated :
Hi @Anonymous ,
Based on my test, it is not possible to meet your requirement currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Dedmon Dai
@Anonymous , You can not initialize date ranges using some function.
You can create a column in date table
Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[Week Name]
)
and use that in filter as this week
Thank you for your answer @amitchandak but I want the user to be still able to slice the date to whatever he wants between the initial min and max date.
I just need a preselection of beginning and end date corresponding to the current week.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |