Forum Discussion
Required Visual Suggestion
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.
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.