Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
You might need a role playing dimension table, please see the tutorial below. hope this helps.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!