Filter two values by one selection in slicer

[Anonymous]

Hi!

My report is calculating Lead and Cycle times for the ticketing system.

Results I get look like this:

Ticket 1	Lead Time	10 min
Ticket 1	Cycle Time	2 days
Ticket 1	Lead Time	10 min
Ticket 2	Lead Time	25 min
Ticket 2	Cycle Time	3 days

Because of the structure of data Lead Time is actually Lead Time + Cycle Time and Cycle Time is Cycle Time only.

My problem is that I would like to filter data with one slicer "Lead Time" that results in a filter "All records that have Lead Time OR Cycle Time" and "Cycle Time" ... "All records that have Cycle Time (only)".

Please help.

[Anonymous · Accepted solution]

I would create a secondary table by "Enter Data" and put it like:

1 Lead Time Lead Time

2 Lead Time Cycle Time

3 Cycle Time Cycle Time

Make the relationship between your main table and this one, by the second column and filter by the first.

Let me know if it helped.

Best Regards,

Duarte Raminhos

[Anonymous]

Thank you! Clean and simple solution.