Forum Discussion
Required Visual Suggestion
Please check your question.
It does not make sense.
You say
- A Clustered BAR representing the total capacity of the User across all projects.
- 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
I have already mention the Input and desired output result
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.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.
