Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

Frequent 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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors