Forum Discussion

TodGrindley's avatar
TodGrindley
Frequent Visitor
8 years ago

Using One slicer for 2 fields

  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...
opticshrew's avatar
opticshrew
Resolver II
8 years ago

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