Forum Discussion
Power bi model relationship
Hi guys need help, how can i dynamically display a persons supervisor from the previous week in power bi, given that the supervisor changes weekly, using date slicer. Also i have a lot of tables used for his/her matrics.
Hi James13 ,
Not sure what model you are using. I made a simple example that will project last week's personnel supervisor based on the maximum date of the slicer.Please refer to the attached pbix file.
You can also refer to the link below to provide more non-private data and expected outputs.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
2 Replies
Hi James13 ,
Not sure what model you are using. I made a simple example that will project last week's personnel supervisor based on the maximum date of the slicer.Please refer to the attached pbix file.
You can also refer to the link below to provide more non-private data and expected outputs.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
- IoannisPhilip
Advocate III
Hi James13 ,
You will need
1. to create a Calendar Table --> examples here
2. use Time intelligence functions for the metrics you mentioned that include the above table --> link here
3. create dimension tables: dimSupervisors and dimEmployees --> link here
Given that you have all the above you should be able to create what you are looking for. If you could provide screenshots or examples, maybe I can support further. Let me know how it goes.
Best,
Ioannis
