Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Independent Date Filter

Hello, I'm working on a report that contains an appended table with three dates (created date, start date, completed date) within one table. If I add a date slicer for any one of these dates, it will...
Need Help
Show and Tell
Tutorial Requests
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous see attached, I hope this is what you are looking for, you can use date slicer to see the numbers.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , You can activate the joins using userelation as long you need the same dates to filter.

Means one date dimension all three dates can work

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

 

Sometime you may need two date dimensions - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 (This is for one date. But you can do for two dates )