Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

How to solve Overlapping Issues in a Activity Tracker Power Bi with Start Date and End Date??

Hi All,

I have created a PowerBi for tracking the Activities of my Team with Start TimeStamp and End TimeStamp. I have a normal graph with the Working hours calculated with EndTime - Start Time DAX. But what happens when the Activities overlap and I need a help in it with DAX formula? 

Can anyone Please help me with it??

Regular Visitor

Hi @v-yetao1-msft .. Thank you for your reply. I havent dervied any visual for Overlapping Graph.I just had a normal graph with End_Time - Start_time(Bar graph). I need a visual overlapping graph with the fields available. Can you help me with it??


Community Support
Community Support

Hi @Nisha_Innola 

Can you explain the the Activities overlap with a sample ? What is the result you want to get ? You can provide a screenshot or pbix file(remove sensitive info) to show your sample and result .


Best Regards,
Community Support Team _ Ailsa Tao

Super User
Super User

@Nisha_Innola So like this? (1) Overlap - Microsoft Power BI Community

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi Greg_Deckler

Thnak you soo much for your reply...I have tired some of these solution already, but didnt work..Let me check with the remaining ones 

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!