Divide the Bar based on Count with the same Category

[third_hicana]

Hi Power BI Experts. Asking for your help please. I wish to divide the category  on the bar based on the count the % capacity required appeared. 

The scenario:

An employee has a maximum percent (ex. 100%, 70% or 50%). He is being assigned with a certain percent to work. If the employee has 100% max percent and he was assigned with 25%, 25% and 50%, I want to see in one bar the division of these 3 percents.

What I have now:

As you can see the 25 percent (which has  "2" count) was merged in the first slice of the bar. I want to split the two 25 percents. 

What I wish to have:

Thank you for your help 🙂

[KNP · Accepted solution]

Makes sense.

I've attached a PBIX file for you to look at.

Before I spend too much time on it, I thought it might be easier to start with this and see what is non-negotiable.

The layout may be difficult to achieve without a custom visual.

There are options for custom visuals but it may not add much value.

All of this working is dependent on the actual model/data so have a look at the PBIX attached and let me know if you have any questions.

(check the Power Query steps to see what I've done there)

[KNP]

Can you paste some sample data please?

It will make it much easier to help you.

[third_hicana]

Hi @KNP  Thank you. Here's the sample data. For the employee 2 in "What I wsh to have" graph, the 30 there is the remaining percent left to the employee. 

Project	Assigned Employee	Percent Assigned
Project A	Employee 1	25
Project B	Employee 1	25
Project C	Employee 1	50
Project D	Employee2	40

Employee	Max Percent
Employee 1	100
Employee 2	70

[KNP]

Thanks for the data.

Unless I'm doing math wrong, I don't get the employee 2 scenario. 

30 + 40 = 70

[third_hicana]

Hi @KNP  I added another table.

I have another table for the list of employees with max percent.

So that math would be
Employee 1 :  100 -25 -25- 50 = 0% (which means 100% is maximised or utilised)

Employee 2 = 70- 40 = 30% (which means 40% assigned , 30% available percent or left from 70% maximum capacity

[KNP · Accepted solution]

Makes sense.

I've attached a PBIX file for you to look at.

Before I spend too much time on it, I thought it might be easier to start with this and see what is non-negotiable.

The layout may be difficult to achieve without a custom visual.

There are options for custom visuals but it may not add much value.

All of this working is dependent on the actual model/data so have a look at the PBIX attached and let me know if you have any questions.

(check the Power Query steps to see what I've done there)

[third_hicana]

Hi @KNP  Thank you very much. 

[KNP · Accepted solution]

No problem. Happy to help.

Did you figure out the max capacity bar?

You may prefer the markers off and line on also.

It's annoying that you can do this layout with a column chart but not a bar chart. 

[third_hicana]

Hi @KNP  the marker is fine. I just really need the division of assigned percent. Superb. Thanks again.