Forum Discussion
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 ID | Created Date | Resolved Date |
| 1234 | 2023-09 | 2023-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
1 Reply
- miTutorialsSuper User
You might need a role playing dimension table, please see the tutorial below. hope this helps.