Filter two values by one selection in slicer

Question

Hi!&nbsp;My report is calculating Lead and Cycle times for the ticketing system.Results I get look like this:Ticket 1Lead Time10 minTicket 1Cycle Time2 daysTicket 1Lead Time10 minTicket 2Lead Time25 minTicket 2Cycle Time3 days&nbsp;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)".&nbsp;&nbsp;Please help.

anonymous · Accepted Answer

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

Forum Discussion

Filter two values by one selection in slicer

2 Replies

Related content

Selecting a slicer source field based on filtered value

Selected-Filtered value calculation

Dynamic filters - Selected Value - DAX

filter table based on selected value using contains

Default value when no filter selected

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