cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vat2do
Helper I
Helper I

Using one slider visual to control 2 different date ranges in power bi

Hi there, Hope all are fine.

 

I have a table showing ticket details with below columns:

ticket no,

create date,

resolved date,

 

 i need to use one slicer visual in power bi desktop to see all the tickets over span of one month. can anyone support with thanks.

1 REPLY 1
amitchandak
Super User
Super User

@vat2do , if you want to filter the same value for both, say a month - Feb 2022. Then you can join both of them with the same date table, one join will be inactive, which you can activate using userelationship

examples

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

 

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors