Headcount Change the value from Active to Actual through the year

[Anonymous]

Hi,

I am creating a graph to show the employee headcount for each month throughout the year in a department.  As the year goes by the manager would like to see the status change from active to actual in the bar chart graph.  In the data file the status is either active or planned. Does anyone know how to do this?

Thanks.

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

You can refer to this post, or you can share pictures.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Power-BI-use-a-previous-date-measure-to-in-future-date-measure/td-p/2453404

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Yalan Wu,

This is a scrrenshot of the graph.

Currently this is based on active emloyees over the year.  The manager would like to see a color change in the column that would indicate the actual employees for previous months.  Is it possible to do that?

Thanks,

SRA1

[v-yalanwu-msft]

Hi, @Anonymous ;

I think it is, you can use conditional format for bar charts.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

I think it is ok, if you can share a simple sample and the result you want to output (in the way of pictures), explain your logic, and then create a measure through DAX. 

It makes it easier to give you a solution.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous I have no idea what do you mean by Active to Actual? What is it?

[Anonymous]

Active are active FTE's.  Actual would reflect that in January through March the FTE's were actual FTE's.

[parry2k]

@Anonymous can you put some sample data and the expected output?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Anonymous]

Thank you fr offering to help, but it isn't possible to attach a file.  I have tried multiple times to add the data in a table, but the system rejects that too.  

[Anonymous]

This is a screenshot of the data file: 

When this is uploaded, I tansform the data by complressing it into two columns, date and status.  I use SUM to give me a total and then CALCULATE to get the count for the status and use a calendar table to get the count by month.

The manager would like to see the count go from ACTIVE to ACTUAL for each month as the year goes on.  Is that possible?

Thanks,