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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.