Reply
jjmanx
Advocate I
Advocate I

FIltering Project Count by Create Date and End Date

Hey all, I hope you can help.

I have 2 visuals, 1 showing a count of projects using a create date, the second showing a count of projects using the end date.

When I select a month on the create date visual it isolates all the projects which have an end date within that same period on the second visual.

What I actually need is when I select a month in the create date visual, I want to see when all of those projects are are due to end. 

i.e. when I select Jan 2022 as the create month, I should see a count of how many of those projects are due to end in June, July, Aug, etc, etc in the second visual.

I'm sure it's something straightforward but I'm at a dead end! Thank you! 🙂

jjmanx_1-1675292307761.png

 

 

1 REPLY 1
amitchandak
Super User
Super User

@jjmanx , I think this can help

 

Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

 

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
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...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)