Forum Discussion

DanielRatvai's avatar
DanielRatvai
Frequent Visitor
2 years ago

Date slicer with two different date

Hello, 

I have a table with ticket information with Created and Resolution Date. 
The customer would like to see two charts in one page, with a creating and a resolving trend. 

It's pretty simple, but they would like to have only one slicer, where you can set the timeframe. 
I thougt its a good idea to connect the two slicer, then if they modify the created date the resolution date will adapt also.


My problem: 
They select to show the tickets from 2023-10
I have a ticket where: 
Table: Ticket_List

Ticket IDCreated DateResolved Date
12342023-092023-10


As the two slicer has the same value (Created >2023-10 and resolved > 2023-10), the second chart wont show this ticket as it doesnt fit for the created slicer. 

Goal: 
Slicer: show the tickets after 2023-10 date
Created chart: wont show the '1234' ticket
Resolved chart: Show the ticket in october. 

Is there any way to solve this or this is simple just not possible, and we should stick to the different slicer solution? 

Thanks,
Daniel