Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
In my Task Table I have 2 fields [Start Date] and [Finish Date]. When I add a slicer, it only allows me to add 1 slicer which is either for Start Date or for Finish Date. (See link below)
https://www.screencast.com/t/5ZRWsaMvNUt
What I want is to have one slice with both fields. That way i can select a Start Date and a Finish Date, and the data will provide me with tasks that are between the selected Dates. To look something like the following the below link.
https://www.screencast.com/t/NDSBKYa0uXVa
Any Ideas? Would appreciate any help I can get. Been stuck on this for quiet some time.
Hi @TodGrindley,
As of now, it is not possible to add two fileds (start date and end date) into a single slicer. For your requirement, you may submit an idea here.
Best regards,
Yuliana Gu
Hi @TodGrindley
The method you've done already is something that many people do and it works it just isn't that intuitive and requires more clicks than should be needed.
What you could do is through the query editor create a new column named "Days Active". Here you would list the days between the start and end date. Your slicer would then be on this field and would only show tasks where they were active on a specific day.
Dates Between
Dates = { Number.From([Start]..Number.From([End]) }
Expand that list to new rows and you'll have the days where a task is active. It might be worth duplicating the table before creating the column to use as reference.
Unique Tasks > Task Details (with column)
Hope this helps,
J
Hi,
In my Task Table I have 2 fields [Start Date] and [Finish Date]. When I add a slicer, it only allows me to add 1 slicer which is either for Start Date or for Finish Date. (See link below)
https://www.screencast.com/t/5ZRWsaMvNUt
What I want is to have one slice with both fields. That way i can select a Start Date and a Finish Date, and the data will provide me with tasks that are between the selected Dates. To look something like the following the below link.
https://www.screencast.com/t/NDSBKYa0uXVa
Any Ideas? Would appreciate any help I can get. Been stuck on this for quiet some time.
There are a couple of approaches you can take:
Task A | 1-Jan-2018 |
Task A | 2-Jan-2018 |
Task A | 3-Jan-2018 |
Task A | 4-Jan-2018 |
Task A | 5-Jan-2018 |
Regards,
Owen
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |