Forum Discussion

RamyaRapolu's avatar
RamyaRapolu
Frequent Visitor
5 years ago

Dynamic target line on stacked bar chart

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. 

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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