Dynamic target line on stacked bar chart

[RamyaRapolu]

Hi 

I want to add target line to the stacked bar chart like below. The actual value is directly coming from a column but the target here is a measure so I am unable to add it to constant line. Same thing is possible with stacked column chart but how to achieve this with stacked bar chart. 

[arindam_sarma]

@RamyaRapolu , have you received any solution to your problem? I also need the exact solution.

[v-shex-msft]

Hi @RamyaRapolu,

AFAIK, some of the analysis lines support measure expressions, but they only allow the expressions that you used in visual value fields.

In my opinion, I'd like to suggest you switch to 'line and stacked bar' chart and use measure expression on line fields to show the target line.

Regards,
Xiaoxin Sheng

[RamyaRapolu]

Thanks for your response. But my requirement is that way. I am still working on it.

[v-shex-msft]

HI @RamyaRapolu,

Did you mind using script-based visuals? (R/python) They allow you to use script and library to manly plot visualization with addition or customize visualizations.

How to Make a Stacked Bar Chart in R Using ggplot2 (rstudio-pubs-static.s3.amazonaws.com)
Regards,

Xiaoxin Sheng