Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
DanielRatvai
Frequent Visitor

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. 

DanielRatvai_0-1702300805323.png

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.

DanielRatvai_1-1702300905751.png


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



1 REPLY 1
miTutorials
Super User
Super User

You might need a role playing dimension table, please see the tutorial below. hope this helps.

 

Dealing with Multiple Date Fields to bring values from same time period in Power BI | MiTutorials (y...

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors