Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
third_hicana
Helper III
Helper III

Divide the Bar based on Count with the same Category

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. 

 

third_hicana_0-1664506802507.png

 

What I wish to have:

third_hicana_1-1664507810220.png

Thank you for your help 🙂

 

2 ACCEPTED SOLUTIONS

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)

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

No problem. Happy to help.

Did you figure out the max capacity bar?

KNP_0-1664517626218.png

 

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. 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

8 REPLIES 8
KNP
Super User
Super User

Can you paste some sample data please?

It will make it much easier to help you.

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

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 AEmployee 125
Project BEmployee 125
Project CEmployee 150
Project DEmployee240

 

Employee Max Percent
Employee 1100
Employee 270

Thanks for the data.

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

30 + 40 = 70

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

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

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)

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

Hi @KNP  Thank you very much. 

No problem. Happy to help.

Did you figure out the max capacity bar?

KNP_0-1664517626218.png

 

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. 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.