Required Visual Suggestion

Question

Hello Experts,To create a Clustered Bar Chart in Power BI where:Each User&nbsp;has two bars:One bar for "Total Capacity" (aggregated across projects).One bar for "Completed Work", broken down by project.The "Completed Work" bar should be split by individual projects (not stacked).The visualization should allow easy comparison between Total Capacity vs. Project-wise Completed Work for each user.UserProjectsCapacityCompleted workStart Date&nbsp;End DateAHCL242224-Jan-2526-Jan-25AHHO6427-Jan-2528-Jan-25AHPA8629-Jan-2531-Jan-25GCL201824-Jan-2526-Jan-25GHO121027-Jan-2528-Jan-25GPA8629-Jan-2531-Jan-25Data:Output:&nbsp;&nbsp;Thanks!

speedramps · Answer

Please check your question.
It does not make sense.
You say&nbsp;

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

but them provide a output example by&nbsp; Project and User.
&nbsp;
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
&nbsp;
&nbsp;
&nbsp;

shoeb1359 · Answer

I have already mention the Input and desired output result&nbsp;

anonymous · Answer

Hi&nbsp;shoeb1359&nbsp;,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])

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

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

shoeb1359 · Answer

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 · Answer

Hi&nbsp;shoeb1359&nbsp;,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 TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Required Visual Suggestion

8 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

chart suggestion

Turning off Suggest a visual

Slicer requirement

Data Visual Suggestions

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