Overlapping opportunities

[Tkb7117]

I have a large dataset where i need to group opportunities that are alive at the same time. Start days and end days in the group will not be in 1:1 alignment but can overlap for proportional periods......help appreciated how to tackle.

[v-lili6-msft]

hi, @Tkb7117

If you could try this: Drill mode in a visualization in Power BI

If not please share a simple sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[CheenuSing]

Hi @Tkb7117,

Pleaser share the data in excel file on OneDrive or GoogleDrive and paste the link here. Also what is the output expected .

Cheers

CheenuSing