Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |