Forum Discussion
Required Visual Suggestion
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.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.In case of multiple Projects then we need to write that many measures. Is there any generic way to acheive this.