Help with Getting a bar visual

[Anonymous]

There are multiple projects, and they have different approve date and deployment date, i want to achieve a date bar graph which each month will show the number of on going projects.

for example for month of April, it should onlu display the count of projects which approve date is before the last day of april (30th april)  and the deployment date of the project is on or after the first day of next month (1st may)

This is only for april, and this calcualtion apply to all other month, and i want them to show on the same visual. Is this possible?

Thankyou!

[Ashish_Mathur]

Hi,

Share some data to work with.  Share it in a format that can be pasted in an MS Excel file.

[Anonymous]

erm i cant share any file here, but it is just one column of project codes, one is approval date and one is deployment date, deployement date is always after approval date

[Ashish_Mathur]

Create a dummy dataset and share that here.

[Anonymous]

Hi, i think it is due to my company security setting, i cant share any dummy files. 

Project code a12-345 a12-346 a12-347 a12-348 a12-349 a12-350 a12-351 a12-352 a12-353 a12-354 a12-355 a12-356 a12-357 a12-358 a12-359 a12-360 a12-361 a12-362 a12-363 a12-364 a12-365 a12-366 a12-367 a12-368 a12-369 a12-370 a12-371 a12-372 a12-373 a12-374 a12-375 a12-376 b23-123 b23-124 b23-125 b23-126 b23-127 b23-128 b23-129 b23-130

SER Biz Approval Date 2022-jan-1 2022-jan-2 2022-jan-3 2022-jan-4 2022-jan-5 2022-Feb-5 2022-Feb-6 2022-Feb-7 2022-Feb-8 2022-Feb-9 2022-mar-12 2022-mar-13 2022-mar-14 2022-mar-15 2022-apr-16 2022-apr-17 2022-apr-18 2022-apr-19 2022-may-20 2022-may-21 2022-may-22 2022-may-23 2022-jun-12 2022-jun-13 2022-jun-14 2022-jun-15 2022-jun-16 2022-jun-17 2022-July-1 2022-July-2 2022-July-3 2022-aug-2 2022-aug-3 2022-aug-4 2022-sep-2 2022-sep-3 2022-sep-4 2022-sep-5 2022-sep-6 2022-sep-7

Deployment Date 2022-jan-31 2022-feb-2 2022-feb-3 2022-feb-4 2022-feb-5 2022-feb-28 2022-mar-3 2022-mar-4 2022-mar-5 2022-mar-6 2022-mar-27 2022-mar-28 2022-apr-20 2022-apr-21 2022-apr-22 2022-may-18 2022-may-19 2022-may-20 2022-june-21 2022-june-22 2022-june-23 2022-june-24 2022-june-25 2022-june-26 2022-july-27 2022-july-28 2022-july-29 2022-july-30 2022-Aug-20 2022-Aug-21 2022-Aug-22 2022-Aug-23 2022-oct-20 2022-oct-21 2022-oct-22 2022-oct-23 2022-oct-24 2022-oct-25 2022-oct-26 2022-oct-27

[Ashish_Mathur]

That data is not a format which can be used.  Could you kinldy paste data in a tabular format.

[amitchandak]

@Anonymous , Refer if the blog or attached files can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

hi i cant understnad the code, can u explain to me or edit it based on my context?

sorry about the inconvenience