Date slider that uses multiple columns

[Anonymous]

I have a data set that has multiple date columns, the date show when the task came in (created date) and when the task was completed (completed date). 

I have created a dashboard that shows this data, however when I select Completed in the slicer at the top I would like the date slider and the date graph to change from "created date" to "completed date" , but keep the inputed dates, is this at all possible? all of this data is held in one table at the moment.

[v-janeyg-msft]

Hi, @Anonymous 

I really want to help you, but I can’t understand what you said ‘keep the inputed dates’ and ‘change from "created date" to "completed date"’, isn’t this contradictory?

Could you mind share some sample data and your desired result? So we can help you soon.

Best Regards

Janey Guo

[amitchandak]

@Anonymous , You can create a date table and join all dates with that. Only one join will active. Use inactive join using userelationship.

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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

https://www.youtube.com/watch?v=e6Y-l_JtCq4