Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts,
I have a time slicer in my report. I am using "Between" view of it. I want user to select only those dates which are present in my dataset. Currently it is showing all dates of +10 and -10 years. How can we disable selection of other dates?
Also, in one of the time slicer (Between View) only one date should come (Showing only Max Date from dataset). I don't want this date to be changed using time slicer. Can we disable selection of dates from Calendar view in timeslicer
I know there are other options in time slicer but I need to use only Between view.
Please advice.
hi, @Mann
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
hi, @Mann
After my research, you could try these way:
1. If you time slicer is from a calendar table that includes date from '2008' to '2028' and create a relationship with other table?
If so, you could use RELATED Function to adjust if this row date is in dataset.
for example:
Use this formula to add a column for calendar
filter = IF(ISBLANK(RELATED(Table1[Date Production]))=TRUE(),1,2)
Then set it into report level filter set is 2
https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview
2. Also, in one of the time slicer (Between View) only one date should come (Showing only Max Date from dataset). I don't want this date to be changed using time slicer. Can we disable selection of dates from Calendar view in timeslicer
If you could use Before View or After View.
Best Regards,
Lin
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |