Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Active opportunities

I have another question, we do have these opportunities that have a start and end date. We would like to have a visual (barchart) X-axis = months jan to dec. Y axis = count of possible opportunity.

Opportunities       -->       startdate       -->       enddate
Opp1                                01/05/2020                31/12/2020
Opp2                                24/04/2020                31/12/2020 

Opp3                                01/03/2020                31/12/2020 
Opp4                                01/03/2020                31/12/2020   
 
Problem here is that it would only count the number of opportunities on the months: march(03) / april (04) / may (05). while these projects do are also active on the months june, july, aug, ... Dec
 
Link to sample pbix file
 
Any ideas?

20 Replies