Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is it possible to Not allow selection of dates beyond those available in dataset?
E.g. if available data is for last 3 months (e.g. Jan, 2020 to Mar, 2020), then after selecting "Between" in date slicer, users should Not be able to click on From Date field and select Nov 2019. This would give the false impression that the data displayed is from Nov 2019 to Mar 2020
Solved! Go to Solution.
hi @Anonymous
It is designed by default, date range slicer and number range slicer has the same limitations,
please refer to this:
The following limitations and considerations apply to the numeric range slicer:
Regards,
Lin
@Anonymous , Not sure I got it completely. But typically if you are using date calendar, then generate it from min to max of you Main table it will allow selection in that date range only
Calendar = calendar(Min(Table[Date]),Max(Table[Date]))
Hi D,
Just tried your solution.
Unfortunately, the users still seem to have a choice of clicking on "From Date" section in the slicer i.e. "4/1/2020" and scrolling back in the calendar to an older date Or clicking on "To Date" section i.e. "6/10/2020" to scroll to a future date using the calendar pop-up.
Is it possible to blur out dates which do not lie between From and To dates?
or Not allow users to scroll through dates which are not in the range of data?
hi @Anonymous
It is designed by default, date range slicer and number range slicer has the same limitations,
please refer to this:
The following limitations and considerations apply to the numeric range slicer:
Regards,
Lin
Thanks Lin,
I guess the work around in this case would be to train users to try to use the Slider feature instead of the calendar And maybe add a date range on the report for clarity.
@Anonymous , This is what I was saying. Not sure We are on the same page.
File attached after Signature
@Anonymous
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |