Forum Discussion
Default Date
- Anonymous5 years ago
Hi Anonymous
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.
However if you use this measure filter in your visual, it won't show values after today or before start day.
I update a new measure, build a date table for slicer.
Measure1 = VAR _MINDate = MIN('Date'[Date]) VAR _MAXDate = MAX('Date'[Date]) Return IF(MAX('Table'[Date])>=_MINDate && MAX('Table'[Date])<=IF(_MAXDate>=TODAY(),_MAXDate,TODAY()),1,0)By this measure it will show dynamic result by slicer.
If we change slicer from 2020/12/01 to 2021/02/19, it will show result we want.
Due to you use Between in slicer, this measure has a disadvantage that if the maxdate in slicer >Today when you open your report, it will show you values in maxdate instead of today.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- 5 years ago
I had same issue. This is what I did if it helps.
I added calcuated column
Is-Today = IF(MyDateTable[Date] <= TODAY(), "True", "False").then i filtered as followsIt works perfectly fine for me.
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
Hi Rico,
Actually I tried making the measure but it does not show me the todays date and the other dates as Zero and One,It just gives me One. Could You post me the Pbix as Mine is connected to Server And U cannot acccess it.
Regards
KAvSar