Forum Discussion
Dynamic date selection and Default Date selection in Slicer
Hi Team,
I am actually trying to make a power bi report where in " The Report must be opened by default today's data and The user must also be able to select the date dynamically from the slicer, I saw many posts but Im unable to figure out a way.I Tried making the today's date but the report is getting fixed for today.I am unable to change it dynamically.
Help would be great.
Thanks In Advance
KavSAr
2 Replies
- amitchandak
Super User
kavsar , Create a column with dates and today
Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
Sort this on date or date 1
Date1 =[Date]
refer
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
Hi kavsar ,
If amitchandak 's approach helps you? If not, please have a try.
Dynamically show today's value by default by slicer is not supported in power bi.In addition to amitchandak 's reply, you can try to build a measure filter and add this filter into filter pane as well.
Measure = IF(MAX('Table'[Date])>= DATE(YEAR(TODAY()),01,01) && MAX('Table'[Date])<=TODAY(),1,0)Set this filter to show items when value =1.
Please refer to the following topic to see if it helps you.
https://community.powerbi.com/t5/Desktop/Default-Date/td-p/1669358
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
