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

[Nisha_Innola]

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??

[Nisha_Innola]

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??

[v-yetao1-msft]

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

[Greg_Deckler]

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

[Nisha_Innola]

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