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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
vat2do
Helper II
Helper II

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.