Required Visual Suggestion

[shoeb1359]

Hello Experts,

To create a Clustered Bar Chart in Power BI where:

1. Each User has two bars:
   • One bar for "Total Capacity" (aggregated across projects).
   • One bar for "Completed Work", broken down by project.
2. The "Completed Work" bar should be split by individual projects (not stacked).
3. The visualization should allow easy comparison between Total Capacity vs. Project-wise Completed Work for each user.
   
   
   

User	Projects	Capacity	Completed work	Start Date	End Date
AH	CL	24	22	24-Jan-25	26-Jan-25
AH	HO	6	4	27-Jan-25	28-Jan-25
AH	PA	8	6	29-Jan-25	31-Jan-25
G	CL	20	18	24-Jan-25	26-Jan-25
G	HO	12	10	27-Jan-25	28-Jan-25
G	PA	8	6	29-Jan-25	31-Jan-25

Data:

Output: 

Thanks!

[shoeb1359]

Hi @amitchandak ,

Hope you are doing well .

Please advise if you have any solution for this. Business users want the same layout.

Thanks in Advance

[speedramps]

Please check your question.

It does not make sense.

You say 

1. A Clustered BAR representing the total capacity of the User across all projects.
2. A Stacked BAR representing the sum of completed work, segmented by individual Projects.

but them provide a output example by  Project and User.

Try provide consistent input data, desired output and step by step description.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Thanks

[shoeb1359]

I have already mention the Input and desired output result

[Anonymous]

Hi @shoeb1359 ,

Power BI does not have and cannot implement visual objects that look like this:

You can use the following workaround:

1. Use two visual objects to display:
Use this DAX to create a measure and create a clustered bar chart:

total capacity = 
CALCULATE(
    SUM('Table'[Capacity]),
    ALL('Table'),
    'Table'[User] = MAX('Table'[User])
)

Then use this DAX to create another measure and create a stacked bar chart:

sum of completed work = SUM('Table'[Completed work])

2. Use only one clustered bar chart but display it in three quadrants

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shoeb1359]

Thanks for Answering but End user wants see the data in 2 bars.
One with total capacity and 2nd bar will have project wise breakdown for completed work.

Is there any custom visual you are aware of by which we can acheive this.

[Anonymous]

Hi @shoeb1359 ,

Oh, you reminded me. In fact, I actually remember there is a custom visual that may meet your needs. Please try this custom visual:

It's just a little bit troublesome, you need to add three additional measures:

sum of CL = 
CALCULATE(
    SUM('Table'[Completed work]),
    'Table'[Projects] = "CL"
)

sum of HO = 
CALCULATE(
    SUM('Table'[Completed work]),
    'Table'[Projects] = "HO"
)

sum of PA = 
CALCULATE(
    SUM('Table'[Completed work]),
    'Table'[Projects] = "PA"
)

Then create the custom visual:

There is a limitation. This visual must have a bar chart, a stacked bar chart, and a line chart to display data. If there is no line chart, it cannot display any data. And it can only be vertical bars, not horizontal bars. I don't know if this will affect you.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shoeb1359]

In case of multiple Projects then we need to write that many measures. Is there any generic way to acheive this.

[Anonymous]

Hi @shoeb1359 ,

I'm sorry, after trying, I only found this custom visual that can meet your needs. But if you want to use this custom visual, you must write a measure for each project after my test, there is no other generic solution. It is by design.
In addition, custom visuals are visual objects created by third parties, so we cannot provide more technical support. If you still have questions, we recommend that you contact the creator of the visual object for help. Thank you.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.